COMPUTE and COMPUTE BY clauses are deprecated

Starting with SQL Server 2012, the COMPUTE and COMPUTE BY clauses are no longer supported, as they are archaic ways of doing printed reports. They do not produce conventional results.

Use GROUPING, ROLLUP or CUBE instead, to produce results that can be stored for further processing or aggregation.

Available in

 SQL Code Guard