Grouping Sets in SQL server 2008
September 23, 2008 in SQL Server by Michael Chrisman 1 Comment
SQL Server 2008 offers an interesting new functionality for Group By queries. It is called a Grouping Set. A Grouping Set allows you to merge multiple Group By queries into one compact query. Let's do an example. Let's say you have a employee billing database that contains the billing history …
