Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Jeff Moden Cross Tabs and Pivots, Part 1 – Converting Rows to Columns RE: Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

  • August 19, 2008 at 5:03 am

    #859895

    Phil Factor (8/19/2008)

    [p]I hope I'm not mentioning anything that you are covering in subsequent articles, but when you need row and column totals, averages, or other aggregations, then suddenly the CUBE and ROLLUP operators start to become very useful. To take your example....[/p]

    Actually, you did, Phil... I'm devestated... 😉

    True enough... that will be in a subsequent article, but you've stolen no thunder. Thank you for the feedback ol' friend.

    --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)