Could implement. Any easier way??

declare @ClaimSequence varchar(2000), @count int, @counter int, @tpin varchar(8000)

SET @ClaimSequence ='101, 1, 300,333|101,2, 30, 400'

CREATE TABLE #temp(id int not null identity(1,1) , sequence...

I don't want to use SSIS.

So far I could get the first split