how to get the Every Friday to Thursday wise data in any Month

Question

Post reply

how to get the Every Friday to Thursday wise data in any Month

narendra.babu57

Old Hand

Points: 386
More actions
February 24, 2012 at 2:26 am

#252180

For example:
Feb 2012
i want bellow format:
1-2 1week,
3-9 2ndweek
10-16 3rdWeek
17-23 4th Week
24-29 5th week

Viewing 5 posts - 1 through 4 (of 4 total)

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

Eugene Elutin SSC Guru Points: 59322 More actions · Answer 1

Here:

http://www.sqlservercentral.com/articles/Best+Practices/61537/

_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)

How to post your question to get the best and quick help[/url]

narendra.babu57 Old Hand Points: 386 More actions · Answer 2

Hi the above link i can not get the solution to my query

Eugene Elutin SSC Guru Points: 59322 More actions · Answer 3

The above link is about how to present your problem to this forum to attract relevant answers in timely matter. Otherwise you will need to wait for someone who has too much of free time....

_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)

How to post your question to get the best and quick help[/url]

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

narendra.babu57 (2/24/2012)
Hi the above link i can not get the solution to my query

Hello and welcome to SSC!

I'd like to be able to help, but it seems you've forgot to post readily consumable sample data and ddl scripts.

If you could read this article[/url] about the best way to post DDL and sample data then edit your post to include it, it would be extremely useful for the unpaid volunteers of this site.

Thanks!

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/