Nice article.

I see Itzik using this approach a lot as well. Personally I like it but is stuck due to a third party program in an lower compatibility level quite...

Unless I am mistaken he had year and month separated so it wouldn't work checking for it until they are combined...

An option:

SELECT DATENAME(month, DATEADD(month, [number], 0)) [MonthName]

, MONTH(DATEADD(month, [number], 0)) [MonthValue]

FROM [master].[dbo].[spt_values]

WHERE [type]='P'

AND [number] BETWEEN 0 AND 11

ORDER...

bkubicek (11/21/2011)

---

You know, I find your comment offensive. I put time and effort into this article and this code. I had a problem to solve that required a...

I do realize this was not the purpose of the article but it made me think of it so here's a recursive version. It'll stop after 100 recursions unless the...