InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 19 May 2013 17:18:23 GMT20http://www.sqlservercentral.com/Forums/Topic1167272-2870-1.aspxNice question on Grouping Sets.Fri, 02 Sep 2011 00:05:49 GMTCoolCodeSharehttp://www.sqlservercentral.com/Forums/Topic1167272-2870-1.aspxInteresting! according to msdn [i]"GROUPING SETS can generate a result equivalent to that generated by a simple GROUP BY, ROLLUP or CUBE operation."[/i]Thank you,IulianThu, 01 Sep 2011 02:08:00 GMTIulian -207023http://www.sqlservercentral.com/Forums/Topic1167272-2870-1.aspxGot new thing . thxWed, 31 Aug 2011 23:42:20 GMTDanny Oceanhttp://www.sqlservercentral.com/Forums/Topic1167272-2870-1.aspxGreat question. I love the ones that show me something new.Wed, 31 Aug 2011 09:08:36 GMTKenneth.Fisherhttp://www.sqlservercentral.com/Forums/Topic1167272-2870-1.aspx[quote][b]sathishmcc (8/30/2011)[/b][hr]Hi, this "grouping sets" available in sql server 2005 i tried it shows error...is it in advanced version.[/quote]That is correct. I began the question with [quote]SQL Server 2008 introduces GROUPING SETS[/quote] so that thier would not be any confusion about the server version that supports it.Wed, 31 Aug 2011 07:58:21 GMTSanDroidhttp://www.sqlservercentral.com/Forums/Topic1167272-2870-1.aspx[quote][b]Tom.Thomson (8/30/2011)[/b][hr][quote][b]SanDroid (8/30/2011)[/b][hr]Thank you Tom.It was your reply to my comments that inspired me to write this question.So I would call it inspiration before plagerism. ;-)This question is based on one posted before.[url]http://www.sqlservercentral.com/questions/T-SQL/64301/[/url]The example scripts, and the answer, are not the same.:cool:[/quote]The important difference, I think, is that in your version the answer is right while in the previous version the answer was wrong. :smooooth:[/quote]Tom I seriously apreciate that. I respect your opinion always. :-)Wed, 31 Aug 2011 07:53:42 GMTSanDroidhttp://www.sqlservercentral.com/Forums/Topic1167272-2870-1.aspx[quote][b]sathishmcc (8/30/2011)[/b][hr]Hi, this "grouping sets" available in sql server 2005 i tried it shows error...is it in advanced version.[/quote]This feature is not available in SQL Server 2005. It works with SQL Server 2008 and newer.Wed, 31 Aug 2011 07:53:29 GMTKWymorehttp://www.sqlservercentral.com/Forums/Topic1167272-2870-1.aspxHi, this "grouping sets" available in sql server 2005 i tried it shows error...is it in advanced version.Tue, 30 Aug 2011 23:43:51 GMTsathishmcchttp://www.sqlservercentral.com/Forums/Topic1167272-2870-1.aspx[quote][b]SanDroid (8/30/2011)[/b][hr]Thank you Tom.It was your reply to my comments that inspired me to write this question.So I would call it inspiration before plagerism. ;-)This question is based on one posted before.[url]http://www.sqlservercentral.com/questions/T-SQL/64301/[/url]The example scripts, and the answer, are not the same.:cool:[/quote]The important difference, I think, is that in your version the answer is right while in the previous version the answer was wrong. :smooooth:Tue, 30 Aug 2011 16:34:20 GMTL' Eomot Inverséhttp://www.sqlservercentral.com/Forums/Topic1167272-2870-1.aspx[quote][b]tim.kay (8/30/2011)[/b][hr]Thanks for this question. As a relative newbie I think I will find this useful in future.[/quote]It can really cut down on the number of times you use UNION ALL. :cool:Tue, 30 Aug 2011 11:25:16 GMTSanDroidhttp://www.sqlservercentral.com/Forums/Topic1167272-2870-1.aspxThanks for this question. As a relative newbie I think I will find this useful in future.Tue, 30 Aug 2011 09:19:35 GMTskankerhttp://www.sqlservercentral.com/Forums/Topic1167272-2870-1.aspx[quote][b]Revenant (8/30/2011)[/b][hr]Thank you, Dee! It compelled me to re-read GROUPING SETS.[/quote]Thank you Revenant. It is a great new feature for grouping and set based query.Tue, 30 Aug 2011 08:56:36 GMTSanDroidhttp://www.sqlservercentral.com/Forums/Topic1167272-2870-1.aspxThank you, Dee! It compelled me to re-read GROUPING SETS.Tue, 30 Aug 2011 08:49:27 GMTRevenanthttp://www.sqlservercentral.com/Forums/Topic1167272-2870-1.aspx[quote][b]Daniel Bowlin (8/30/2011)[/b][hr]I did a little reading, got the question right, but the reading I did makes me want to read a lot more about commands I have not used in the past that I think I will find quite useful. Thanks[/quote]You are very welcome Daniel. Thank you for the response! :-DTue, 30 Aug 2011 08:01:20 GMTSanDroidhttp://www.sqlservercentral.com/Forums/Topic1167272-2870-1.aspxI did a little reading, got the question right, but the reading I did makes me want to read a lot more about commands I have not used in the past that I think I will find quite useful. ThanksTue, 30 Aug 2011 07:35:21 GMTDaniel Bowlinhttp://www.sqlservercentral.com/Forums/Topic1167272-2870-1.aspx[quote][b]stewartc-708166 (8/30/2011)[/b][hr]Nice simple question.Having recently embarked on a project which requires the use of grouping sets really helped[/quote]This helped me with some recent reporting projects also.Tue, 30 Aug 2011 07:18:06 GMTSanDroidhttp://www.sqlservercentral.com/Forums/Topic1167272-2870-1.aspx[quote][b]Tom.Thomson (8/30/2011)[/b][hr]Nice and straightforward.I have a strange feeling that I've seen exactly those two queries before somewhere. ;-)But maybe I won't cry "plagiarism" :unsure:. Or :ermm: maybe I should?[/quote]Thank you Tom.It was your reply to my comments that inspired me to write this question.So I would call it inspiration before plagerism. ;-)This question is based on one posted before.[url]http://www.sqlservercentral.com/questions/T-SQL/64301/[/url]The example scripts, and the answer, are not the same.:cool:Tue, 30 Aug 2011 07:12:20 GMTSanDroidhttp://www.sqlservercentral.com/Forums/Topic1167272-2870-1.aspxThanks for the question. This is a feature I have not been able to play with too much, but one that I can see some uses for.MattTue, 30 Aug 2011 07:06:49 GMTMattrickhttp://www.sqlservercentral.com/Forums/Topic1167272-2870-1.aspxThank you everyone so far for the positive comments.I truely apreciate all your feedback.Tue, 30 Aug 2011 07:06:18 GMTSanDroidhttp://www.sqlservercentral.com/Forums/Topic1167272-2870-1.aspxNice learning question, thanks.Tue, 30 Aug 2011 05:44:28 GMTBritt Cluffhttp://www.sqlservercentral.com/Forums/Topic1167272-2870-1.aspxNice Question.Tue, 30 Aug 2011 05:30:32 GMTKameswari Aravindhhttp://www.sqlservercentral.com/Forums/Topic1167272-2870-1.aspxnice question!!!Good example to use the GROUPING SETS operatorTue, 30 Aug 2011 05:01:54 GMTrfr.ferrarihttp://www.sqlservercentral.com/Forums/Topic1167272-2870-1.aspxNice and straightforward.I have a strange feeling that I've seen exactly those two queries before somewhere. ;-)But maybe I won't cry "plagiarism" :unsure:. Or :ermm: maybe I should?Tue, 30 Aug 2011 03:47:01 GMTL' Eomot Inverséhttp://www.sqlservercentral.com/Forums/Topic1167272-2870-1.aspxNice simple question.Having recently embarked on a project which requires the use of grouping sets really helpedTue, 30 Aug 2011 01:05:58 GMTStewart "Arturius" Campbellhttp://www.sqlservercentral.com/Forums/Topic1167272-2870-1.aspxThanks for the question.Tue, 30 Aug 2011 00:02:33 GMTSQLRNNRhttp://www.sqlservercentral.com/Forums/Topic1167272-2870-1.aspxThanks for the question. Still haven't really played with this feature yet. I could see how some reports might be easier to read using this syntax.Mon, 29 Aug 2011 22:57:41 GMTKWymorehttp://www.sqlservercentral.com/Forums/Topic1167272-2870-1.aspxComments posted to this topic are about the [url]/questions/Aggregates/75489/[/url] "Grouping Sets"This question was inspired by one posted before.[url]http://www.sqlservercentral.com/questions/T-SQL/64301/[/url]Mon, 29 Aug 2011 20:12:57 GMTSanDroid