Comma Seperated Values Insertion In SQL server 2005

Posted by Asim Sajjad on Stack Overflow See other posts from Stack Overflow or by Asim Sajjad
Published on 2010-04-08T04:38:12Z Indexed on 2010/04/08 4:43 UTC
Read the original article Hit count: 371

Filed under:
|

How can I insert Values from the comma separated input paramater to the Store prodcedure ? Example is

exec StopreProcedure Name 17,'127,204,110,198',7,'162,170,163,170'

you can see that I have two Comma Separated Values in the parameter list , both will have same number of values if first have 5 comma seperated value then second one also has 5 comma separated values you can says

127 and 162 are related 204 and 170 are related and same for other how can I insert these two values in ? One comma Sepated value is inserted but how to insert two ?

© Stack Overflow or respective owner

Related posts about sql-server-2005

Related posts about sql