A nice piece of recursive SQL – Split a delimited string into separate records

I was trying to break a delimited string down today in to a separate record for each delimited value and came across this gem that uses recursion.

http://stackoverflow.com/questions/5493510/turning-a-comma-separated-string-into-individual-rows