Home Forums Article Discussions Article Discussions by Author Discuss content posted by Hugo Kornelis Updating through cursors RE: Updating through cursors

  • July 24, 2008 at 5:25 am

    #847639

    or because you run into one of the very rare problems where a cursor actually runs faster than a set-based solution

    Hi Hugo,

    Do you have an example of when that might occur? I ask because so many people write hidden RBAR into solutions such as running total problems and call them "set based" just because they don't contain an explicit Cursor or While loop.

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