SQLpassion BLOG

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 …

The power of Grouping Sets in SQL Server + read more