The power of Grouping Sets in SQL Server
Have you ever wanted to perform aggregations across multiple columns/dimensions in SQL Server without licensing SSAS (SQL Server Analysis Services)? I am not talking about using the Developer edition in production, nor am I talking about installing a pirate copy of SQL Server. Mission Impossible? Not really, because it’s possible through the so-called Grouping Sets …
