• Cool concept and well written article, but this is not the best way to split a string.

    I've performance tests on this and the SQL while loop.

    The XML version seems slick at first, but slows down terribly when size of the string increases.

    And Jeff's tally method leaves the while loop far behind.

    http://www.sqlservercentral.com/articles/T-SQL/62867/