SQL SERVER – Use ROLL UP Clause instead of COMPUTE BY
- by pinaldave
Note: This upgrade was test performed on development server with using bits of SQL Server 2012 RC0 (which was available at in public) when this test was performed. However, SQL Server RTM (GA on April 1) is expected to behave similarly.
I recently observed an upgrade from SQL Server 2005 to SQL Server 2012 with compatibility keeping at SQL…