Eralper (3/16/2010)
You can find reference documents about the code for sql split string function
Yikes. XML is not the right tool for the job when it comes to string splitting.
The tally-table method presented by Lutz, Bob, and Jeff is far, far, superior.
Almost as good a a CLR string splitting function in fact.
Comprehensive test results: http://florianreischl.blogspot.com/2009/09/high-performance-string-split-functions.html
Paul
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi