• sharath.chalamgari (9/21/2011)


    Congrats Jeff, this will be really inspirational for other sql folks.

    Thanks, Sharath. I really do hope this helps inspire others especially when it comes to sharing knowledge. I try to help because the "teacher" in me gets a great thrill to watch someone's "light" come on. What I didn't realize when I first started sharing info is how much good info comes back to you... there's always someone with a nifty trick that you might not have thought of. The "Tally Oh" and "Replace Multiple Spaces" articles are prime examples of where just such a thing happened. Just several hours after each article came out, someone either made an improvement that I'd not thought of or came up with an alternate method that was even better than the one I wrote about.

    The old saying is "Nothing ventured, nothing gained." Believe it. Help others and you'll be amazed at how much knowledge people will share in return.

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