SQL Server takes all the dates or all the months in a certain time period

Take all months:

DECLARE @begin datetime, @end datetime set @begin = ' 2015-2-6 ' Set @end = ' 2015-12-2 ' declare @months int set @months =datediff ( Month, @begin, @end) Select CONVERT (varchar (7), DATEADD (Month,number, @begin), as month from Master.dbo.spt_values where Type= ' P ' and number<[email protected]

Take all dates

DECLARE @days INT,  @date_start datetime = ' 2017-03-15 ',  @date_end datetime = ' 2017-04-13 '   SET @days = datedif F (Day, @DATE_START, @DATE_END);    SELECT convert (char), DATEADD (DD, number, @DATE_START), as YYYYMMDD from    master.dbo.spt_values as  Sptwhere   type = ' P ' and number  <= @days

You can then do some left join operations with a table to get a date that has not occurred for some time in a table. A small function to use to record a bit.

SQL Server takes all the dates or all the months in a certain time period