August 20, 2008 at 5:27 am
If I have date values as follow.
7/13/2008
7/14/2008
7/15/2008
7/16/2008
7/17/2008
7/18/2008
7/19/2008
7/20/2008
7/21/2008
7/22/2008
7/23/2008
7/24/2008
7/25/2008
7/26/2008
I have to generate a calender weekly report with the above dates
I need to represent 7/13/2008 to 7/16/2008 as week1,7/17/2008 to 7/23/2008 as week2 and 7/24/2008 to 7/26/2008 as week3
How can I do this?
Thanks.
August 20, 2008 at 5:29 am
data will be upto one year not just the dates that were given above.
and we can change the start date and end date.
August 20, 2008 at 5:35 am
Please post table structure with some sample records.
I suggest you to read the below article.
http://www.sqlservercentral.com/articles/Best+Practices/61537/
karthik
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply