Try this

Declare @Value char(12)

SET @Value = your char(12) value for 106 format

to get to 106 format

Use this

Select Convert(Char(12),getdate(),106)

This will clarify the date format after that

SET the @Value...

Did u try the set datefirst function from T-sql.It actually sets the firstdate of week to Monday. Then on this you can aggregate on the datepart(wk,date) function. To top...