http://blogs.msdn.com/craigfr/archive/2007/10/11/grouping-sets-in-sql-server-2008.aspxIn my last two posts, I gave examples of aggregation WITH ROLLUP and CUBE . SQL Server 2008 continues to support this syntax, but also introduces new more powerful ANSI SQL 2006 compliant syntax. In this post, I'll give an overview of the changes. First,enCommunityServer 2.1 SP1 (Build: 61025.2)http://blogs.msdn.com/craigfr/archive/2007/10/11/grouping-sets-in-sql-server-2008.aspx#8029327Tue, 04 Mar 2008 19:32:21 GMT91d46819-8472-40ad-a661-2c78acb4018c:8029327Technical Musings<p>SQL Server 2008 will be coming out sometime this summer (in theory). At last week's TechFuse event in Minneapolis, and in blogs I sometimes read, I've started to pick up on a number of useful features and improvements that should...</p> http://blogs.msdn.com/craigfr/archive/2007/10/11/grouping-sets-in-sql-server-2008.aspx#9385121Fri, 30 Jan 2009 21:52:23 GMT91d46819-8472-40ad-a661-2c78acb4018c:9385121hugo_shebbeare<p>As reporting requirements increase, it seems that aggregate functions have thankfully risen to the occasion</p> http://blogs.msdn.com/craigfr/archive/2007/10/11/grouping-sets-in-sql-server-2008.aspx#9402379Fri, 06 Feb 2009 18:43:24 GMT91d46819-8472-40ad-a661-2c78acb4018c:9402379hugo_shebbeare<p>As reporting requirements increase, it seems that aggregate functions have thankfully risen to the occasion</p> http://blogs.msdn.com/craigfr/archive/2007/10/11/grouping-sets-in-sql-server-2008.aspx#9806615Sat, 27 Jun 2009 16:58:56 GMT91d46819-8472-40ad-a661-2c78acb4018c:9806615dance2die<p>Looking at the table that shows &quot;four possible aggregations&quot; really helped me understand the concept of GROUPING SETS</p>