• Using GROUP BY with ROLLUP, CUBE, and GROUPING SETS (Books Online)

    Grouping Sets In SQL Server 2008 (Craig Freedman's Blog)

    Those were my first two matches using Google Search.

    Paul