building a calendar for a month (3), Sql Server

Language: Layout:

DECLARE @year INT, @month INT;
    SET @year = YEAR(GetDate());
    SET @month = 1;
    SET DATEFIRST 7;

WITH CTE_DATES AS
    (
        SELECT 
         DATEADD(DAY, 1-DATEPART(WEEKDAY, DATEFROMPARTS(@year, @month, 1)), DATEFROMPARTS(@year, @month, 1)) AS [Date],
         DATEFROMPARTS(@year, @month, 1) AS initDate,
         DATEADD(dd, 7-(DATEPART(dw, EOMONTH(DATEFROMPARTS(@year, @month, 1))   )), EOMONTH(DATEFROMPARTS(@year, @month, 1)))  AS endDate

UNION ALL

SELECT DATEADD(day,1, [Date]), initDate, endDate
        FROM CTE_DATES
        WHERE [Date] < endDate
    ), 
    CTE_CALENDAR AS
    (
      SELECT 
       (CASE
        WHEN MONTH(initDate) = 1 AND DATEPART(WW, [Date]) > 50
        THEN 1
        WHEN YEAR([Date]) > YEAR(initDate)
        THEN DATEPART(WW, EOMONTH(initDate))
        ELSE DATEPART(WW, [Date])
        END) AS [WeekID], 
       DATENAME(WEEKDAY, [Date]) AS [Day],
       CONVERT(VARCHAR(10),[Date],23) AS [Date]
      FROM CTE_DATES
    )
    SELECT *
    FROM CTE_CALENDAR
    PIVOT 
    (
       MAX([Date]) 
       FOR [Day] IN ([Sunday] , [Monday], [Tuesday], [Wednesday], [Thursday], [Friday], [Saturday])
    ) Pvt
    ORDER BY [WeekID];

View schema
Execution time: 0,03 sec, rows selected: 7, rows affected: 0, absolute service time: 0,73 sec, absolute service time: 0,75 sec