how to get the data week wise in sql server

Question

how to get the data week wise in sql server

Viewing 2 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply

Cadavre SSC-Forever Points: 41690 More actions · Answer 1

narendra.babu57 (3/1/2012)
The above code is not working for 29,30 th dates for all months

Which above code? Did you use the CLR?

Forever trying to learn
My blog - http://www.cadavre.co.uk/
For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better, quicker answers on SQL Server performance related questions, click on the following...http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Cadavre SSC-Forever Points: 41690 More actions · Answer 2

Also, read this article --> http://www.sqlservercentral.com/articles/Best+Practices/61537/%5B/url%5D, then setup your sample data and DDL script in a readily consumable format. After you've done that it's much easier to help.

I coded the CLR to work with the NVARCHAR date in the format you specified in your first post, which is different to the format you are now stating. With sample data, we avoid this confusion.

Forever trying to learn
My blog - http://www.cadavre.co.uk/
For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better, quicker answers on SQL Server performance related questions, click on the following...http://www.sqlservercentral.com/articles/SQLServerCentral/66909/