http://blogs.msdn.com/craigfr/archive/2007/09/21/aggregation-with-rollup.aspxIn this post, I'm going to discuss how aggregation WITH ROLLUP works. The WITH ROLLUP clause permits us to execute multiple "levels" of aggregation in a single statement. For example, suppose we have the following fictitious sales data. (This is the sameenCommunityServer 2.1 SP1 (Build: 61025.2)http://blogs.msdn.com/craigfr/archive/2007/09/21/aggregation-with-rollup.aspx#5172075Thu, 27 Sep 2007 21:39:11 GMT91d46819-8472-40ad-a661-2c78acb4018c:5172075Craig Freedman's WebLog<p>In my last post, I wrote about how aggregation WITH ROLLUP works. In this post, I will discuss how aggregation</p> http://blogs.msdn.com/craigfr/archive/2007/09/21/aggregation-with-rollup.aspx#5183857Fri, 28 Sep 2007 13:30:07 GMT91d46819-8472-40ad-a661-2c78acb4018c:5183857mknee<p>Great post - I'm sure many people would consder this &quot;the basics&quot; but it was new to me &amp; VERY useful. </p> <p>Thanks!</p> <p>Mike Knee</p> http://blogs.msdn.com/craigfr/archive/2007/09/21/aggregation-with-rollup.aspx#5402552Thu, 11 Oct 2007 19:32:53 GMT91d46819-8472-40ad-a661-2c78acb4018c:5402552Craig Freedman's SQL Server Blog<p>In my last two posts, I gave examples of aggregation WITH ROLLUP and CUBE . SQL Server 2008 continues</p>