• Eralper (7/10/2009)


    Hello all,

    I have placed the XML string split logic into a user defined function and I think running the split within the function results better in performance than keeping the split login inline.

    You can check the result with an other example at Split String using XML - How to Convert or Split a Delimited String Values to Rows using T-SQL XML Commands

    Eralper

    SQL Programming

    Can I ask why you are using this function and passing it along to others?

    Performance is pretty horrible compared to other ways to split a string.