kherald69 (8/8/2014)
You can use a recursive common table expression to achieve this.
That's a recursive CTE that counts. Please see the following article for why that's a bad idea even for small date ranges.
http://www.sqlservercentral.com/articles/T-SQL/74118/
--Jeff Moden
Change is inevitable... Change for the better is not.