Home Forums Article Discussions Article Discussions by Author Discuss content posted by Amit Gaur Convert String to a Table using CTE RE: Convert String to a Table using CTE

  • December 14, 2009 at 5:57 am

    #1091886

    Liked the article thanks.

    But, uh-oh, here we go again with the string-splitting debate...:laugh:

    Like it or not, the overall best method ever is to use a CLR TVF. It just is.

    http://sqlblog.com/blogs/adam_machanic/archive/2009/04/28/sqlclr-string-splitting-part-2-even-faster-even-more-scalable.aspx

    Paul

    Paul White
    SQLPerformance.com
    SQLkiwi blog
    @SQL_Kiwi