title: T-SQL - stored procedure that would handle an unknown number of parameters of unknown types
body: <p>I have a large number of stored procedures that basically do the same thing: get a list of values as parameters, then go to some table and SELECT all the rows WHERE these values match.</p>
  
  <p>I would like to be able to have a single stored procedure that would be able to handle all these cases.</p>
  
  <p>How would you tackle this?</p>