• Lynn Pettis - Wednesday, November 22, 2017 3:55 PM

    Jeff Moden - Wednesday, November 22, 2017 3:50 PM

    drew.allen - Wednesday, November 22, 2017 8:25 AM

    Jeff Moden - Wednesday, November 22, 2017 8:20 AM

    The formatting thing has been a problem ever since they "improved" the forum software.  :angry:

    You can't blame this one on the forum software.  The code was not included in the proper SQL Code tags.

    Drew

    If you look at the code that was included in the tags, it still sucks. 😉  I'm also thinking that it wasn't copied and pasted directly from SSMS either.

    I try NOT to copy/paste directly from SSMS, it adds extra lines that I can't seem to remove.  I go to a text editor, UltraEdit, first.  Even then I have had issues with the SQL Code block at times.

    It didn't use to be that way just before this latest change.  They spent a good amount of time making sure that the code windows worked great and they did.  All that is gone now and it doesn't matter whether you use IE, FireFox, Chrome, or whatever Web Browser you prefer.

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