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)

  • Simply comment the compute part and replace with a SELECT statement

    -- 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 dbo.##FO

    Would work for all SQL Server versions.

    --------------------------------------------------------------------------------------------------
    I am just an another naive wannabe DBA trying to learn SQL Server