USE BELOW CODE...

--DROP TABLE #temp1

declare @STR varchar(100)='12345678910111213141516'

declare @pos varchar(50)='1,1,2,5,4,2'

declare @t int=0

create table #temp1(id varchar(100))

WHILE CHARINDEX(',',@pos)>0

BEGIN

set @t=SUBSTRING(@pos,1,(CHARINDEX(',',@pos)-1))

INSERT INTO #temp1 VALUES( substring(@str,1,@t))

SET @pos=SUBSTRING(@pos,(CHARINDEX(',',@pos))+1,LEN(@pos))

set @STR=SUBSTRING(@str,(@t+1),len(@str))

END

INSERT INTO #temp1 VALUES (SUBSTRING(@str,1,CONVERT(INT,@pos)))

--INSERT INTO @T1 VALUES(@VAL)

SELECT * FROM #temp1