I would like to pass a list of ids to my stored proc for use in a statment like:
SELECT pr.name where pr.id IN ('23,25,27' FROM profiles pr
so that the list following the IN statement is a replaceable parameter. How do I declare the parameter in my stored procedure?