nZac · January 15, 2015 18:53
diff --git a/date_list.sql b/date_list.sql
 -- Create a list of dates incremented by month

 DECLARE @MinDate DATE = '20120101',
        @MaxDate DATE = '20150101';

 SELECT  TOP (DATEDIFF(MONTH, @MinDate, @MaxDate) + 1)
 		full_date = DATEADD(MONTH, ROW_NUMBER() OVER(ORDER BY a.object_id) - 1, @MinDate)
 FROM    sys.all_objects a
        CROSS JOIN sys.all_objects b
	-- Create a list of dates incremented by month

	DECLARE @MinDate DATE = '20120101',
	@MaxDate DATE = '20150101';

	SELECT TOP (DATEDIFF(MONTH, @MinDate, @MaxDate) + 1)
	full_date = DATEADD(MONTH, ROW_NUMBER() OVER(ORDER BY a.object_id) - 1, @MinDate)
	FROM sys.all_objects a
	CROSS JOIN sys.all_objects b