Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag grouping sets Rss

Search for any content tagged grouping sets

   Items 1 to 6 of 6   
 

Stairway to T-SQL DML Level 8: Using the ROLLUP, CUBE and GROUPING SET operator in a GROUP BY Clause

In this article I will be expanding on my discussion of the GROUP BY clause by exploring the ROLLUP, CUBE and GROUPING SETS operators. These additional GROUP BY operators make it is easy to have SQL Server create subtotals, grand totals, a superset of subtotals, as well as multiple aggregate groupings in a single SELECT statement.  Read more...
By Gregory Larsen 2012/08/22 | Category: stairway series
Rating: |  Discuss |   Briefcase | 11,097 reads

SQL Server 2008 T-SQL Enhancements Part - I

SQL Server 2008 has a number of enhancements over 2005 that make it a more capable platform. New author Arshad Ali brings us an overview and some code about a few T-SQL changes.  Read more...
By Arshad Ali 2010/03/05 (first published: 2009/01/22) | Source: SQLServerCentral.com | Category: sql server 2008
Rating: |  Discuss |   Briefcase | 39,510 reads

All the Aggregates you crave with Grouping Sets in SQL Server 2008

As reporting requirements increase, it seems that aggregate functionalities have thankfully risen to the occasion concurrently. To maintain its competitive edge as Staples Canada’s best vendor, BaldGorilla, where I’m currently consulting, has been able...   Read more...
By Hugo Shebbeare 2009/02/05 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 1,444 reads

SQL Server 2008 T-SQL Enhancements Part - I

SQL Server 2008 has a number of enhancements over 2005 that make it a more capable platform. New author Arshad Ali brings us an overview and some code about a few T-SQL changes.  Read more...
By Arshad Ali 2010/03/05 (first published: 2009/01/22) | Source: SQLServerCentral.com | Category: sql server 2008
Rating: |  Discuss |   Briefcase | 39,510 reads

Grouping with SQL Server 2008

Don Schlichting examines several SQL Server 2008 grouping functions including GROUP BY, GROUPING SETS, CUBE, and ROLLUP. In addition, he demonstrates how to use SUM and COUNT in a WHERE clause after rows have been grouped.  Read more...
By Additional Articles 2009/01/13 | Source: Database Journal | Category: t-sql
Rating:  Rate this |   Briefcase | 3,073 reads

Grouping Sets in SQL Server 2008

This article shows how to use the GROUPING SETS feature in SQL Server 2008  Read more...
By Additional Articles 2008/11/19 | Source: SQL Server Performance | Category: sql server 2008
Rating:  Rate this |   Briefcase | 2,972 reads
   Items 1 to 6 of 6