Dan English's BI Blog

Welcome to my random thoughts in regards to Business Intelligence, databases, and other technologies

Archive for April 24th, 2008

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.

Did you know? SQL Server 2008 includes GROUPING SETS from Dan English on Vimeo.

Posted in SQL Server | Tagged: , , | Leave a Comment »