CREATE PROCEDURE My1stSProc @ListParam AS varchar(100) AS DECLARE @Sql nvarchar(4000) SET @Sql = 'SELECT ItemID, ItemDesc FROM dbo.ItemMaster' + ' WHERE ItemID IN (' + @ListParam + ')' EXECUTE(@Sql)