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;