LutzM (1/7/2012)
You'll need the DelimitedSplit8K function to split the data. If you don't have it in your tool box already, search this site for it (originally posted by Jeff Moden).
Lutz,
Thank you for the reference but you might want to update the "Delimited Split Function" link in your signature to the newer, more performant version at the following link...
http://www.sqlservercentral.com/articles/Tally+Table/72993/
--Jeff Moden
Change is inevitable... Change for the better is not.