Friday, August 12, 2011

One Way to generate dates from CTE

WITH cteDate AS(

SELECT 0 AS N UNION ALL SELECT N + 1 FROM cteDate
WHERE N < 11)

SELECT StartOfMonth = DATEADD(mm,N,'2010') FROM cteDate;

No comments:

Post a Comment