Grouping Sets

Question

Grouping Sets

SanDroid

SSChampion

Points: 10068
More actions
August 29, 2011 at 8:12 pm

#243908

Comments posted to this topic are about the /questions/Aggregates/75489/ "Grouping Sets"
This question was inspired by one posted before.
http://www.sqlservercentral.com/questions/T-SQL/64301/
August 30, 2011 at 1:05 am

This was removed by the editor as SPAM

Viewing 15 posts - 1 through 15 (of 26 total)

You must be logged in to reply to this topic. Login to reply

Ken SSCoach Points: 17191 More actions · Answer 1

Thanks 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.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 2

Thanks for the question.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

TomThomson SSC Guru Points: 104773 More actions · Answer 3

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?

Tom

rfr.ferrari SSCertifiable Points: 6879 More actions · Answer 4

nice question!!!

Good example to use the GROUPING SETS operator

[font="Times New Roman"]rfr.ferrari[/font]
DBA - SQL Server 2008
MCITP | MCTS

remember is live or suffer twice!
the period you fastest growing is the most difficult period of your life!

Kameswari Aravindh SSCrazy Points: 2380 More actions · Answer 5

Kameswari Aravindh

SSCrazy

Points: 2380

August 30, 2011 at 5:30 am

#1374893

Nice Question.

Britt Cluff SSCertifiable Points: 5083 More actions · Answer 6

Nice learning question, thanks.

http://brittcluff.blogspot.com/

SanDroid SSChampion Points: 10068 More actions · Answer 7

Thank you everyone so far for the positive comments.

I truely apreciate all your feedback.

Mattrick Ten Centuries Points: 1176 More actions · Answer 8

Thanks 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.

Matt

SanDroid SSChampion Points: 10068 More actions · Answer 9

Tom.Thomson (8/30/2011)
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?

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.

http://www.sqlservercentral.com/questions/T-SQL/64301/

The example scripts, and the answer, are not the same.:cool:

SanDroid SSChampion Points: 10068 More actions · Answer 10

stewartc-708166 (8/30/2011)
Nice simple question.
Having recently embarked on a project which requires the use of grouping sets really helped

This helped me with some recent reporting projects also.

Daniel Bowlin SSC-Dedicated Points: 34566 More actions · Answer 11

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

SanDroid SSChampion Points: 10068 More actions · Answer 12

Daniel Bowlin (8/30/2011)
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

You are very welcome Daniel. Thank you for the response! 😀

Revenant SSC-Forever Points: 42467 More actions · Answer 13

Thank you, Dee! It compelled me to re-read GROUPING SETS.