1 week 1 01-01-2013 to 01-07-2013 2 week 2 01-08-2013 to 01-16-2013 3 week 3 01-17-2013 to 01-23-2013 4 week 4 01-24-2013 to 01-30-2013 5 week 5 01-31-2013 to 01-06-2013
1 Week-1 2012-12-30 00:00:00.000 2013-01-05 00:00:00.000 2 Week-2 2013-01-06 00:00:00.000 2013-01-12 00:00:00.000 3 Week-3 2013-01-13 00:00:00.000 2013-01-19 00:00:00.000 4 Week-4 2013-01-20 00:00:00.000 2013-01-26 00:00:00.000 5 Week-5 2013-01-27 00:00:00.000 2013-02-02 00:00:00.000
select (ww,'1-Jan-2013')
select Column1,datepart(ww,Column2) from TableName
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)