COMPUTE is depreciated. You can use ROLLUP or GROUP BY
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂