Split Function in Sql stored procedure

Soniad

Hello,

I am new to stored procedure, i am passing one parameter to stored procedure (comma seperated). i want to know how to split this variable inside stored procedure.

i want to split '1,2,3,4,5' in commas and to loop through these numbers.
how to do..???

Regards,
"D"

Jan 24 '09 #1

ck9663

Depends on what you're going to do with it. What do you have so far?


-- CK

Jan 24 '09 #2

Soniad

@ck9663
I want to split these numbers (1,2,3,4,5) and want to insert this id one by one in a table. if it was in vbscript or javascript i wud have done it..but don't have any idea how to do in stored procedure..the only idea i have is that by using CHARINDEX it cud be done.but how??
any suggestion please..


Regards,
"D"

Jan 25 '09 #3

ck9663

Use this technique.


-- CK

Jan 25 '09 #4

Soniad

@ck9663
Thanks for ur assistance.

Regards,

"D"

Jan 31 '09 #5