Did you know? SQL Server 2008 includes GROUPING SETS
Posted by denglishbi on April 24, 2008
SQL Server 2008 includes GROUPING SETS:
Grouping Sets is an extension to the GROUP BY clause that lets users define multiple groupings in the same query. Grouping Sets produces a single result set that is equivalent to a UNION ALL of differently grouped rows, making aggregation querying and reporting easier and faster.
Read more about this in the SQL Server 2008 BOL ‘GROUPING SETS’.
Check out a screencast about the new GROUPING SETS feature in SQL Server 2008 here.