;with CTE as 
(
Select ID, LEFT(Data, CHARINDEX(';',Data+';')-1),
    STUFF(Data, 1, CHARINDEX(';',Data+';'), '')
from temp_res
union all
select ID, LEFT(Data, CHARINDEX(';',Data+';')-1),
    STUFF(Data, 1, CHARINDEX(';',Data+';'), '')
from CTE
where Data > ''
)

Select * from CTE
Order by ID

quote:

---

Originally posted by kirank

Hi,

one of my sp return records like this
@selectVal= 'a;b;c;d;f;e;r;g;'

i have one table call temp_res, on SP i need to write a logic where i can loop thr the string and insert into table(temp_res) just want it to split the result base on ;(semicolun) and insert new records

can you plz suggest me thanx in advance,

---------------------------

http://codingstuffsbykiran.blogspot.com | http://webdevlopementhelp.blogspot.com

---

INSERT table(temp_res)
SELECT Val
FROM dbo.ParseValues(@selectVal,';')f