• Ironically, the very techniques talked about in this article apparently haven't been exercised for the recent forum update and one of the most important parts of this site, the SQL Code windows, still doesn't work correctly.  They still double-space and delete leading spaces if you copy and paste from SSMS.  They still come up with all sorts of wonky colorization if you make a trip through NotePad (for example) to preserve the spaced indentation.  What happened to test and UAT?

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