Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Transact-SQL (2000)  EZ Stored Proc Array question

Author  Topic  elomon Starting Member 37 Posts Posted - 2001-10-25 : 16:27:14 I've got a SP that is doing a LIKE comparison. I want to pass the SP a comma separated list of values but am having trouble executing SP, how do I format list to pass correctly? Here's SP: CREATE PROCEDURE sp_sample @email_list nvarchar(4000),@cust_code VarChar(15) AS Select * Where customer_code=@cust_code AND customer_email IN (@email_list) GO How to properly execute this SP? Here's what I tried: sp_sample ('b@smith.com',etc),'custcode' I did see the article on passing an array to a SP but it doesn't mention how to execute it.