Hi,
I've been searching all over the internet but not coming up with a satisfactory answer.
Basically, I have this query:
select datepart(week, created_dt) as week_no from myTable
which gives me: 1, 2, 3, etc for "week_no"
but since this is for a report, I also want the ACTUAL date the week_no is referencing, for example Jan 3, 2011.
Thanks much
I've been searching all over the internet but not coming up with a satisfactory answer.
Basically, I have this query:
select datepart(week, created_dt) as week_no from myTable
which gives me: 1, 2, 3, etc for "week_no"
but since this is for a report, I also want the ACTUAL date the week_no is referencing, for example Jan 3, 2011.
Thanks much