Запрос на подсчет суммы - SQL Server - Ответ 2744411

CREATE TABLE #tmp(
[MONTH] INT,
[Quarter] INT,
[YEAR] INT,
[Num1] INT,
[Num2] INT)
INSERT INTO #tmp 
VALUES(1,1,2006,10,5)
INSERT INTO #tmp 
VALUES(1,1,2006,5,10)
INSERT INTO #tmp 
VALUES(2,1,2006,10,5)
INSERT INTO #tmp 
VALUES(2,1,2006,5,10)
INSERT INTO #tmp 
VALUES(3,1,2006,10,5)
INSERT INTO #tmp 
VALUES(3,1,2006,5,10)
INSERT INTO #tmp 
VALUES(4,2,2006,10,5)
INSERT INTO #tmp 
VALUES(4,2,2006,5,10)
INSERT INTO #tmp 
VALUES(5,2,2006,10,5)
INSERT INTO #tmp 
VALUES(5,2,2006,5,10)
INSERT INTO #tmp 
VALUES(6,2,2006,10,5)
INSERT INTO #tmp 
VALUES(6,2,2006,5,10)
INSERT INTO #tmp 
VALUES(7,3,2006,10,5)
INSERT INTO #tmp 
VALUES(7,3,2006,5,10)
INSERT INTO #tmp 
VALUES(8,3,2006,10,5)
INSERT INTO #tmp 
VALUES(8,3,2006,5,10)
INSERT INTO #tmp 
VALUES(9,3,2006,10,5)
INSERT INTO #tmp 
VALUES(9,3,2006,5,10)
INSERT INTO #tmp 
VALUES(10,4,2006,10,5)
INSERT INTO #tmp 
VALUES(10,4,2006,5,10)
INSERT INTO #tmp 
VALUES(11,4,2006,10,5)
INSERT INTO #tmp 
VALUES(11,4,2006,5,10)
INSERT INTO #tmp 
VALUES(12,4,2006,10,5)
INSERT INTO #tmp 
VALUES(12,4,2006,5,10)
SELECT 1 AS [Sort], *
FROM #tmp
UNION 
SELECT DISTINCT [Sort], isnull([MONTH], 13) [MONTH],
isnull([Quarter], 5) [Quarter], [YEAR], Num1, Num2
FROM
(SELECT 2 AS [Sort],
[MONTH], [Quarter], [YEAR],
SUM(Num1) Num1, SUM(Num2) Num2
FROM #tmp
GROUP BY [MONTH], [Quarter], [YEAR]
WITH cube) AS sums
WHERE ([YEAR] IS NOT NULL) 
AND (([Quarter] IS NULL AND [MONTH] IS NULL) OR ([Quarter] IS NOT NULL))
ORDER BY 4,3,2 
 
DROP TABLE #tmp