RE: Get data month to calander week

SSC Guru

Points: 1003853

December 23, 2013 at 5:45 am

Oh, be careful with that. The "week" datepart can change based on the setting of DATEFIRST. And, no... you shouldn't count on that setting.

I'm on my way to work. I'll see what I can do when I get home. Maybe someone else will pick this up in the meantime.

--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)