RSS

Re: query for creating report group by weeks (with start date and end date of the week)

Please support our MS SQL advertiser: Programming Forums

query for creating report group by weeks (with start date and end date of the week)

•

Join Date: Jul 2006

Posts: 17

Reputation: newMeg is an unknown quantity at this point

Rep Power: 3

Solved Threads: 0

newMeg

Offline

Newbie Poster

Re: query for creating report group by weeks (with start date and end date of the week)

Apr 23rd, 2007

Hi David,

Thanks for the reply. But I was wondering why do we use date part as datepart function is to get the date different either in weeks or days or months right?

From the sql u just provided, i'm not sure but i guess it was missing the date type for datepart(dy,wk). I added the dy and there was no error but the result of the query returns a number for the weeks.

Attached is the result of the query.

Hey sorry you had to bear with me, but i sthis how the result should be. return an integer representation of the date part or the weeks date?

Attached Images

sqlnew.JPG (38.1 KB, 5 views)

DaniWeb Home > Forums > Web Development > Databases > MS SQL > query for creating...

Re: query for creating report group by weeks (with start date and end date of the week)

query for creating report group by weeks (with start date and end date of the week)

Re: query for creating report group by weeks (with start date and end date of the week)