Introduction: This post describes a new feature in SQL Server 2008 – Grouping Sets The result set returned by GROUPING SET is the union of the aggregates based on the columns specified in each set in the Grouping set. Whenever an aggregate function is required, GROUPBY clause is the only solution...