Declare @StartDate date = '20200531'
;With Numbers As
(Select 0 As Number, @StartDate As Date
Union All
Select Number + 1, DateAdd(day, 1, Date)
From Numbers
Where Date < Cast(GetDate() As date))
Select Convert(char(11), n.Date, 106) As Date,
DateDiff(Month, @StartDate, n.Date) + 1 As MonthNumber
From Numbers n
Order By n.Date
Option(MaxRecursion 0);
Tom