Home Forums SQL Server 2005 Development Problem segregating third occurence from a column RE: Problem segregating third occurence from a column

  • May 7, 2009 at 11:05 am

    #990533

    Gianluca Sartori (5/7/2009)

    ... ooops!

    I vote for Lynn's solution! There's also an interesting thread on this topic

    http://www.sqlservercentral.com/Forums/Topic695508-338-1.aspx

    Uh huh... just be careful with what you see in some of the posts on that thread. There's a lot of really good information but some of the testing used data where the position of the delimiters from row to row didn't vary much and the optimizer recognized that resulting in some artificially fast times in some cases. The devil's in the data.

    The originator of that post is actually writing an article on the subject and will likely coalesce some of those findings.

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