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