Sql server - stored procedure

[KClark]

How do I pass a comma separated list to a single parameter.

eg
Create procedure [PROCESSLIST] @unit_list varchar (255)
.
.
.



exec process list 'market,finance,IT'

 

[tlbroadbent]

It appears that your code for passing the string to the SP is correct. I suspect the question is really, "How do I parse a comma delimited string in a stored procedure?" There are three parameter parsing scripts available for download at SWYNK.COM. One should fill your need.

http://www.swynk.com/sqlscripts/misc7.asp

If I've incorrectly interpreted your question, please provide more detail. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.