获取两个日期之间的季度列表（SQL）

你可以尝试这样的事情，如果你有很多季度要列出，你需要覆盖最大递归：

DECLARE @start_date DATE = '20170101';
DECLARE @end_date DATE = '20170615';
WITH x AS (
    SELECT
        YEAR(@start_date) AS [year],
        DATEPART(QUARTER, @start_date) AS [quarter]
    UNION ALL
    SELECT
        CASE 
            WHEN [quarter] = 4 THEN [year] + 1
            ELSE [year]
        END AS [year],
        CASE
            WHEN [quarter] = 4 THEN 1
            ELSE [quarter] + 1 
        END AS [quarter]
    FROM
        x
    WHERE
        [year] <= YEAR(@end_date)
        AND [quarter] < DATEPART(QUARTER, @end_date))
SELECT * FROM x;