您可以完全在sql中这样做，如下所示。
我冒昧地用月份数除以4来定义季度。

(DATEPART(MONTH, [Date]) / 4) + 1

显然，如果这不适合你，那么你可以用你需要的任何逻辑来代替它。

-- Table Structure
CREATE TABLE Invoice (
    Id INT IDENTITY(1,1) PRIMARY KEY,
    Date DATE NOT NULL,
    Amount DECIMAL(6,2) NOT NULL
);
GO
-- Sample Data (1000 rows)
;WITH CTE_1000 AS (
    SELECT TOP 1000 ROW_NUMBER() OVER (ORDER BY object_id) r
    FROM sys.all_objects
)
INSERT INTO Invoice (Date, Amount)
SELECT
    DATEADD(DAY, r - 1, '20200101'),
    ROUND(RAND(CHECKSUM(NEWID())) * 1000, 2)
FROM CTE_1000;
GO
-- Aggregate Query
;WITH CTE_Quarters AS (
    SELECT
        DATEPART(YEAR, [Date]) [Year],
        (DATEPART(MONTH, [Date]) / 4) + 1 [Quarter],
        [Amount]
    FROM [Invoice]
)
SELECT
    [Year],
    [Quarter],
    SUM([Amount]) [SumAmount]
FROM CTE_Quarters
GROUP BY [Year], [Quarter]
ORDER BY [Year], [Quarter];

sql小提琴：http://sqlfiddle.com/#!18/73778/3