CREATE TABLE #TEMP(id INT,fes INT,bus INT,snacks INT,other INT);
INSERT INTO #TEMP VALUES(1,400,200,50,20),
(2,350,100,20,0);
SELECT ISNULL(CAST(ID AS VARCHAR(50)),'TOTAL') AS ID,
SUM(Fes) AS Fes,SUM(Bus) AS Bus,SUM(Snacks) AS Snacks,
SUM(Other) AS Other,SUM(Fes+Bus+Snacks+Other) AS TOTAL
FROM #Temp
GROUP BY CUBE(ID);
---------------------------------------------
ID Fes Bus Snacks Other TOTAL
------------------------------------------------
1 400 200 50 20 670
2 350 100 20 0 470
TOTAL 750 300 70 20 1140