Every day for the next couple of weeks, I aim to highlight one of SQL Server 2008’s new features, simply for awareness. You can then go away and research the area and report back to me, we’ll then discuss how these new features can benefit us all.
Wednesday 16th June 2010
Grouping Sets are an extension to the GROUP BY clause that lets you define multiple groupings in the same query.
It allows you to produce a single result set that is equivalent to a UNION ALL of differently grouped rows. This will make aggregation querying and reporting easier and faster.