Hi all,

Is this possible to create stored proc with dynamic parameter as an input?

For example, I have a table like this :

id value
== =====
1 'A'
2 'B'
3 'C'
4 'D'
5 'E'

How to create stored proc to returns values from above table but with dynamic id
as an input?

For ex, how to return values, if with id in (1,2) or id in (1,2,5), etc.

In select statement, it will equal to statement like this :
select value from table where id in (1,2) or
select value from table where id in (1,2,5)

Thanks in advance,
Best regards,
incendio.