DECLARE @startofyear DATETIME, @endofyear DATETIME SET @startofyear = DATEADD(yy, DATEDIFF(yy,0,getdate()), 0) SET @endofyear = DATEADD(yy, DATEDIFF(yy,0,getdate()) + 1, -1); WITH sample AS ( SELECT @startofyear AS [Date] UNION ALL SELECT DATEADD(dd, 1, [Date]) FROM sample s WHERE DATEADD(dd, 1, [Date]) <= @endofyear) SELECT * FROM sample option (maxrecursion 370) –loop not more than 370, change to zero to infinite
Wednesday, July 2, 2014
T-SQL: Get a list of dates
Returns a list of dates from first of year to end of year
Labels:
T-SQL
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment