Split the month as weeks

Question

Post reply

Split the month as weeks

KpSQL123

SSC Veteran

Points: 253
More actions
January 21, 2010 at 3:21 am

#136655

Hi,
Can some one please let me know how to split the month as weeks. Let's take January has 6 months
1-2 as 1st week
3-9 as 2nd week
10-16 as 3rd week
17-23 as 4th week
24-30 as 5th week
31 as 6th week.
again feb 1-6 as 1st week....etc
Thanks much

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

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

Chandra Sekhara Vyas Dhara SSChampion Points: 10207 More actions · Answer 1

Check the following link

http://www.windows-tech.info/15/1deebf8c350ee4b2.php

Dave Ballantyne SSC-Dedicated Points: 33667 More actions · Answer 2

Use a calendar table

http://sqlserver2000.databases.aspfaq.com/why-should-i-consider-using-an-auxiliary-calendar-table.html

Clear Sky SQL
My Blog[/url]

Jeff Moden SSC Guru Points: 1004363 More actions · Answer 3

KpSQL123 (1/21/2010)
Hi,
Can some one please let me know how to split the month as weeks. Let's take January has 6 months
1-2 as 1st week
3-9 as 2nd week
10-16 as 3rd week
17-23 as 4th week
24-30 as 5th week
31 as 6th week.
again feb 1-6 as 1st week....etc
Thanks much

I see what you've written but what do you actually want for an output?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

KpSQL123 SSC Veteran Points: 253 More actions · Answer 4

I need to get the transactions weekly for previous weeks from current week.

The weeks should considerd as mentioed in my previous thread