Grouping Sets

  • SanDroid

    SSChampion

    Points: 10068

    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/

  • Ken Wymore

    SSCoach

    Points: 16429

    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: 281205

    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

  • This was removed by the editor as SPAM

  • TomThomson

    SSC Guru

    Points: 104772

    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

    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

    Nice Question.

  • Britt Cluff

    SSCertifiable

    Points: 5083

    Nice learning question, thanks.

    http://brittcluff.blogspot.com/

  • SanDroid

    SSChampion

    Points: 10068

    Thank you everyone so far for the positive comments.

    I truely apreciate all your feedback.

  • Mattrick

    Ten Centuries

    Points: 1176

    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

    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

    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

    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

    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

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

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

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