Home Forums SQL Server 2012 SQL Server 2012 - T-SQL trying to add third grouping set to return average aggregate RE: trying to add third grouping set to return average aggregate

  • February 17, 2014 at 9:59 pm

    #1689723

    KoldCoffee (2/17/2014)

    Do you mind telling me if I could have added something to my existing query to get avg too?

    To be honest, I've never had to use GROUPING SETS before and would have to read up on them to answer that question.

    Is the problem that I "pivoted" all of the data and that your really need them in the "vertical" format of your original query?

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)