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