Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Pre 2012 Stored Procedure: Need some DEV advice (COMPUTE BY TO WITH ROLL UP) RE: Pre 2012 Stored Procedure: Need some DEV advice (COMPUTE BY TO WITH ROLL UP)

  • 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)