It is a modified version of original script I found on net. This script creates conditional Update statements too.
2007-07-05 (first published: 2006-10-03)
This is another type of split function which disects 8000 byte varchar with given delimeter and returns table with disected values.It does that with single select statement (internally looped), without using explicit while loop.Works pretty fast
2007-02-06 (first published: 2006-08-18)