I really apologize for those who felt this question is wrong. 🙂

It works fine in 2005. good Question!

nice one! 🙂 its strange!

SET DATEFIRST 1

;WITH days(Date) AS

(

--Get 13th of this month

SELECT CAST(CAST(YEAR(GETDATE()) AS VARCHAR(4)) + '-' + CAST(MONTH(GETDATE()) AS VARCHAR(2)) + '-13' AS DATETIME)

...

Good one! 🙂 but I am not much comfortable with UNION ALL. what you say?

My point of view is if you can use "BETWEEN AND" for comparing dates, avoid >,< all such symbols. Isnt it true?

I am so sorry for assume it is your post. Please never mind it. I would like more suggestion and more abstract version of it. what i think is SQL...

Well what you designed is too good. What i created is part of script and to practice it with datetime function with minimum loops included.

While browsing your article i...