Grouping data based on weeks

[jaybuffet]

I need a query or SP that groups data by week.

tblNum

Date        Number
------------------
1/1/03         5
1/3/03         7
1/7/03         2
2/3/03         1
2/5/03         6
etc...

And I want to convert that to

week               Total
------------------------
1/1/03 - 1/7/03      14
1/8/03 - 1/14/03      0
...
2/1/03 - 2/5/03       7
etc...

Any help would be appreciated

Thanks
Jason

 

[twifosp]

Use the datepart function

select datepart(week,week),
total
from table

It will give you the number of the week each value falls on.
From there you will need to write literals.

 

[clarkin]

Group By & ranges - exactly what I asked in my first question on this forum:

thread183-420517

If you can't get your solution from that post what you have so far.

Posting code? Wrap it with code tags: [ignore]

[/ignore][code]CodeHere

[ignore][/code][/ignore].