how to pass multiple values using stored procedure?

Question

I want to pass multiple values using stored procedure ?

select * from Mytable where column1 in ('aa','bb','cc')

now i want to passed these column1 parameters using stored procedure

how can i do that?

How about passing table variable as parameter? http://stackoverflow.com/questions/772777/sane-fast-method-to-pass-variable-parameter-lists-to-sqlserver2008-stored-proced?rq=1 — shahkalpesh, Dec 20 '13 at 11:03
select * from Mytable where Exec "Your Proc" in ('aa','bb','cc') — Vignesh Kumar A, Dec 20 '13 at 11:16

score 2 · Accepted Answer · answered Dec 20 '13 at 11:22

2

Try with this:

SELECT * 
FROM Mytable
WHERE CHARINDEX(',' + CAST(Column1 AS varchar) + ',', @YourParameter)  > 0

answered Dec 20 '13 at 11:22

Milen

Another note here: `@YourParameter` should start and end with `,` otherwise will miss the first and the last item from your list of comma separated values. – Milen Dec 20 '13 at 12:34

1 Answers1