T-SQL Tuesday #016 - Summarizing data using GROUPING SETS()

I have been watching the TSQL Tuesday Blog Parties for quite some time and this is the first time I am participating in it. T-SQL Tuesday #16 is hosted by Jes Schultz Borland and the topic is Aggregation . Aggregating and summarizing data is a common business requirement. Very often we come across requirements...