SQL Server - Convert Weekly range

Hello All,

Iam trying to convert the query to weekly range what iam doing wrong

DATEADD

(WW, DATEDIFF(W,1,Otr.START_DATETIME),0)

My results like now when passing the dates '1/11/2011' to

'12/31/2011'

Date      Data
2677-03-05 00:00:00.000   17983.880000000000
2677-03-12 00:00:00.000   18927.590000000000
2677-03-19 00:00:00.000   18246.410000000000
2677-03-26 00:00:00.000   18632.550000000000
2677-04-02 00:00:00.000   18911.180000000000




Thanks
hameed

Do you have a group by clause

ex.

--Weekly
SELECT Department, DATEADD(wk, DATEDIFF(wk, 0, DateCol ), 0) WeekStart, COUNT(EmpID) [Weekly] 
FROM DData
GROUP BY Department, DATEADD(wk, DATEDIFF(wk, 0, DateCol ), 0) 

Make query as folloiwng way

Use SUM with Group By

RB/SATISH S,

Thank you very much the totals (vol) are fine have problem in date if i run 1/1/2012 to 1/14/2012 . Is it possible that date show 2012-01-01 00:00:00.000  ,  2012-01-08 00:00:00.000 ?

Result now is below .
Date                                     VOL
2012-01-02 00:00:00.000    1085.00
2012-01-09 00:00:00.000    1100.00


I am doing fine below to get desired dates  2012-01-01 00:00:00.000  ,  2012-01-08 00:00:00.000  ?

SELECT  DATEADD(wk, DATEDIFF(wk, 0, START_DATETIME ), -1) Date, SUM(vol)
FROM TABLE WHERE ...
GROUP BY DATEADD(wk, DATEDIFF(wk, 0, START_DATETIME ), -1)
ORDER BY DATEADD(wk, DATEDIFF(wk, 0, START_DATETIME ), -1)


Thanks and Regards,
Hameed

Thanks you very much :)
For your kindness and help always.


Thanks
Hameed