SQLServerCentral / Discuss Content Posted by Gregory Larsen / Article Discussions / Article Discussions by Author / Stairway to T-SQL DML Level 8: Using the ROLLUP, CUBE and GROUPING SET operator in a GROUP BY Clause / Latest Posts

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

Robin Sasson — Thu, 23 Aug 2012 01:57:55 GMT

Good article and clear explanation. Had do refactor the INSERT statements as my organisation uses SQL 2005.

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

JGBW12 — Wed, 22 Aug 2012 14:18:28 GMT

test

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

brichardson 56244 — Wed, 22 Aug 2012 09:23:55 GMT

Nice article! I had never really thought much about using those powerful options with GROUP BY, but now I will use them more.--Bill

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

BarneyL — Wed, 22 Aug 2012 01:41:25 GMT

Thanks for this, it's a good clear summary of these features.Are there any performance gains to be had by switching to use these features over unioning a set of SQL statements together? If so I have a few reports that might benefit from rewriting to use them. Barney

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

dbuendiab — Wed, 22 Aug 2012 00:39:08 GMT

Good article, but I've been surprised with the use of COALESCE() for getting the 'Grand Total' in Listing 3. I think it's better to use the GROUPING() function to know if we are dealing with a subtotal row, and then replace the NULL with the correct label. If you use COALESCE() and there is some NULL value in the column CheckFor, you'll get a mistaken label.

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

subramanian.rajan — Tue, 21 Aug 2012 23:39:47 GMT

[quote][b]Greg Larsen (1/10/2012)[/b][hr]Comments posted to this topic are about the item [B]<A HREF="/articles/Stairway+Series/87629/">Stairway to T-SQL DML Level 8: Using the ROLLUP, CUBE and GROUPING SET operator in a GROUP BY Clause</A>[/B][/quote]It is an amazing article on the Rollup, Cube and Grouping SEt operators. Excelling explanation and very good presentation with very simple example.

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

Greg Larsen — Tue, 10 Jan 2012 09:55:46 GMT

Comments posted to this topic are about the item [B]Stairway to T-SQL DML Level 8: Using the ROLLUP, CUBE and GROUPING SET operator in a GROUP BY Clause[/B]