Amount pr. week

[lhg1]

Hi

I have a need list a amount pr. week but since the date format is quite tricky I can't get it to work.

This is an sql to get the tickets.

SELECT ticketid
CONVERT(VARCHAR, DATEADD(ss, TIME_WORK_START - DATEDIFF(ss, GETDATE(), GETUTCDATE()), '1970-01-01 00:00'), 120),
from table

The result of the query should be something like this.
week amount
30 12
31 13
32 14

Thanks.
LHG

 

[bborissov]

Check Datepart() function in BOL.
You can pass [wk] as first parameter that will return you the Week Number of the date you passed.
Read carefully the whole article to see what week number you can get when you change SET DATEFIRST.

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.