Post reply

"Running totals" query

  • June 27, 2013 at 8:56 pm

    #1628182

    Barkingdog (6/27/2013)

    Alan,

    Thanks for the great URL on triangular JOINS and an equally great solution.

    BD

    Be really, really careful. It's not called the "Quirky Update" just for fun. If you use this on a permanent table, you have to follow ALL of the rules and you have to use the latest code in the article which includes a "safety numbering system" to alert you if someone creates a condition (like changing the clustered index) that interferes with the order of the update.

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

Viewing post 16 (of 16 total)

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