http://blogs.msdn.com/b/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 sameen-USTelligent Evolution Platform Developer Build (Build: 5.6.50428.7875)http://blogs.msdn.com/b/craigfr/archive/2007/09/21/aggregation-with-rollup.aspx#10370893Thu, 22 Nov 2012 10:40:21 GMT91d46819-8472-40ad-a661-2c78acb4018c:10370893Deepak Ugale<p>Post really helps to understand the basic use of ROLLUP</p> <div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10370893" width="1" height="1">http://blogs.msdn.com/b/craigfr/archive/2007/09/21/aggregation-with-rollup.aspx#10155920Tue, 19 Apr 2011 19:27:58 GMT91d46819-8472-40ad-a661-2c78acb4018c:10155920Sonal Bhosale<p>Thanx a lot!!!!</p> <div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10155920" width="1" height="1">http://blogs.msdn.com/b/craigfr/archive/2007/09/21/aggregation-with-rollup.aspx#10036736Sat, 10 Jul 2010 14:13:03 GMT91d46819-8472-40ad-a661-2c78acb4018c:10036736Rakesh Dewangan<p>Very helpful, thanks for writing blog.</p> <p>gr8 work!!!</p> <p>Keep it up </p> <div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10036736" width="1" height="1">http://blogs.msdn.com/b/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> <img src="http://blogs.msdn.com/aggbug.aspx?PostID=5402552" width="1" height="1">http://blogs.msdn.com/b/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> <div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=5183857" width="1" height="1">http://blogs.msdn.com/b/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> <img src="http://blogs.msdn.com/aggbug.aspx?PostID=5172075" width="1" height="1">