Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Daily SQL Server 2008 New Feature – Day 24

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

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.

Comments

No comments.

Leave a Comment

Please register or log in to leave a comment.