Pass MultiValue Parameter to Store Procedure

[johnnieh]

I need to create and call a store procedure that has a Select statement with an IN clause in the WHERE Condition.
The data type of the field is int.
How do I pass the variable to the IN clause?

Stored Procedure:
sp_GetRecords
@IDList
AS
SELECT *
FROM TABLE
WHERE IDField IN @IDList

 

[JohnDTampaBay]

Dynamic SQL will solve this. Create the procedure thusly:

sp_GetRecords
  @IDList varchar(200)
AS
BEGIN
  DECLARE @sql varchar(500)

  SET @sql = "SELECT * FROM table WHERE IDField IN (" + @IDList + ")"

  EXEC (@sql)
END

Pass the list of IDs to the stored procedure as a comma-separated list:

sp_GetRecords '1,3,5,7,9,11'

--Angel
-----------------------------------
SELECT * FROM users WHERE clue > 0
0 row(s) selected