Have now tried adding a GROUP BY 'Column' WITH ROLLUP, but still same error...
IF @Count = 1 -- when only 1 row, no need to sum up total
SELECT [Object Name], [Type], [Rows], [Total(MB)],[-], [Unused(MB)],[==], [Used(MB)],[=],
[Index(MB)],[+],[Data(MB)]
FROM ##FO ORDER BY ID ASC
ELSE
BEGIN
--EXECUTE dbo.proc_EmulateComputeQuery
SELECT [Object Name], [Type], [Rows], [Total(MB)],[-], [Unused(MB)],[==], [Used(MB)],[=],
[Index(MB)],[+],[Data(MB)]
FROM ##FO ORDER BY ID ASC
--COMPUTE SUM([Total(MB)]), SUM([Unused(MB)]), SUM([Used(MB)]), SUM([Index(MB)]), SUM([Data(MB)])
SELECT SUM([Total(MB)]), SUM([Unused(MB)]), SUM([Used(MB)]), SUM([Index(MB)]), SUM([Data(MB)]) FROM ##FO
GROUP BY [Total(MB)] WITH ROLLUP
END
END
RETURN (0)