Home Forums SQL Server 2005 T-SQL (SS2K5) Need Charindex to Pick Up the Second Instance RE: Need Charindex to Pick Up the Second Instance

  • November 1, 2011 at 7:30 am

    #1401600

    sdownen05 (10/31/2011)

    Not a problem, Jeff. Thanks for calling me on that.

    ....

    However, I just noticed Ninja's_RGR'us post. That code is much better than mine.

    Thanks, Steve. That's the spirit. Now you know the 2 reasons why I ask for such a thing...

    1. We all might learn something new from you especially since you're the closest to the problem.

    2. We do a double check on your code for you just to make sure. Think of it as a "peer review" to try to help keep you out of trouble. I've seen lots of folks coin their own solution from suggestions and have it turn out wrong.

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