Alternate String Splitter (XML)
SQL Server 2000: Tested
SQL Server 2005: Tested
SQL Server 2008: Tested
SQL Server 2008R2: Tested
SQL Server 2012: Not Tested
Date: 11 Mar 2011
This is a novel way of converting (pivoting) a delimited string into a table. I'm not sure it would be very performant, and may be an example of what can be done rather than what should be done but then I've been badly beaten by developer's inadvisable/inappropriate use of shiny new XML features in the past, so I'm probably biased.
Anyway, this makes use of the XML Nodes function to pivot the delimited string into a table. In this case, a multiple character delimiter is possible.