I'm contructing a stored proc like the following:
CREATE PROCEDURE Select_Widgets
Select * From Table1
Where WidgetID In(@WidgetsList )
but am getting the following error from sql server 2k when running through the debugger: 'Syntax error converting the varchar value '2,5' to a column of data type int'. The target field is an int, so I'm passing a comma delimited list of int values without quotes around each value.