• We're in a 2012 Forum so I'll assume SQL 2012. Support for COMPUTE was dropped from SQL Server 2012 and is not available under any compatibility mode. Use ROLLUP instead.

    http://technet.microsoft.com/en-us/library/ms144262.aspx

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato