One of the solutions to this problem is to pass array of the values to the stored procedure as an XML string parameter and use OPENXML rowset provider inside of the stored procedure to select values ...