This is a great idea.

Thanks for posting.

Hi-

How about something like the following. It may have some bugs but can be used as a starting point.

drop procedure sp_splitIntoIndividualComponents

go

create procedure sp_splitIntoIndividualComponents

As

declare @str varchar(200)

set @str = '2,3,4,5,6,7,8,9,'

;With t1(n1, str1,...