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:09 am

    #859900

    Peter Smith (8/19/2008)

    Jeff Moden (8/18/2008)

    Comments posted to this topic are about the item

    What a performance! Access SQL had the Pivot command from 1992, it's taken 13 years for SQL proper to catch up. About to convert an Access db to a SQL Express back-end. I imagine the X-tab queries will be a major nightmare.

    pj

    I agree... thanks for the feedback, Peter. You'd think that if MS wanted to make it easier, they'd have come up with something a lot easier than Pivot syntax. What would be interesting would be to do a million row test on manual cross-tab vs the automatic cross-tab functionality in Access. If it's done right, the automatic cross-tab should should win by a significant margin.

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