http://blogs.msdn.com/craigfr/archive/2007/09/27/aggregation-with-cube.aspxIn my last post, I wrote about how aggregation WITH ROLLUP works. In this post, I will discuss how aggregation WITH CUBE works. Like the WITH ROLLUP clause, the WITH CUBE clause permits us to compute multiple "levels" of aggregation in a single statement.enCommunityServer 2.1 SP1 (Build: 61025.2)http://blogs.msdn.com/craigfr/archive/2007/09/27/aggregation-with-cube.aspx#5402553Thu, 11 Oct 2007 19:32:55 GMT91d46819-8472-40ad-a661-2c78acb4018c:5402553Craig 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> http://blogs.msdn.com/craigfr/archive/2007/09/27/aggregation-with-cube.aspx#5676263Thu, 25 Oct 2007 22:06:51 GMT91d46819-8472-40ad-a661-2c78acb4018c:5676263Craig Freedman's SQL Server Blog<p>One of the most important uses of CTEs is to write recursive queries. In fact, CTEs provide the only</p>