Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » Rollup and Cube   (RSS)

GROUPING SETS in SQL Server 2008

In 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,
Posted by craigfr | 4 Comments

Aggregation WITH CUBE

In 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.
Posted by craigfr | 2 Comments

Aggregation WITH ROLLUP

In 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 same
Posted by craigfr | 3 Comments
 
Page view tracker