quote:

---

Originally posted by Idera

How do you define your week?Is it the week of the year or the month?


Limitations live only in our minds. But if we use our imaginations, our possibilities become limitless.

PBUH

---

declare @tblReturns as table(dates date,store varchar(20),totals varchar(2))

insert into @tblReturns

select '1/1/2010','Store1','34'union all
select'1/1/2010','Store2','23'union all
select'1/2/2010','Store1','15'union all
select'1/2/2010','Store2','34'union all
select'1/3/2010','Store1','43'union all
select'1/3/2010','Store2','24'union all
select'1/4/2010','Store1','45'union all
select'1/4/2010','Store2','34'union all
select'1/5/2010','Store1','26'union all
select'1/5/2010','Store2','27'union all
select'1/6/2010','Store1','34'union all
select'1/6/2010','Store2','44'union all
select'1/7/2010','Store1','23'union all
select'1/7/2010','Store2','56'union all
select'1/8/2010','Store1','45'union all
select'1/8/2010','Store2','33'union all
select'1/9/2010','Store1','31'union all
select'1/9/2010','Store2','54'union all
select'1/10/2010','Store1','43'union all
select'1/10/2010','Store2','42'union all
select'1/11/2010','Store1','25'union all
select'1/11/2010','Store2','43'union all
select'1/12/2010','Store1','27'union all
select'1/12/2010','Store2','51'union all
select'1/13/2010','Store1','43'

select * from @tblReturns

select 
'WeekNo' + '' + convert(varchar,datepart(week,dates))as week,
store,
SUM(convert(int,totals))Orders
from @tblReturns
group by datepart(week,dates),store