StartDate和EndDate之间每个季度的天数- SQL Server

DECLARE @StartDate DATE = '2022-01-01';
DECLARE @EndDate DATE = '2022-12-31';

WITH CTE AS (
    SELECT @StartDate AS StartDate, DATEADD(QUARTER, 1, DATEADD(QUARTER, DATEDIFF(QUARTER, 0, @StartDate), 0)) AS EndDate
    UNION ALL
    SELECT DATEADD(QUARTER, 1, StartDate), DATEADD(QUARTER, 1, EndDate)
    FROM CTE
    WHERE DATEADD(QUARTER, 1, StartDate) <= @EndDate
)
SELECT StartDate, EndDate, DATEDIFF(DAY, StartDate, EndDate) AS DaysInQuarter
FROM CTE
OPTION (MAXRECURSION 0);