Good morning everyone,
Any ideas how I can use an "IN" operator with a SelectCommand Parameter.
"SELECT * FROM tblEIT WHERE DEPT_ID IN (@DEPTS)"
Where @DEPTS is a value stored in a Cookie. Cookie("DEPTS").Value is "232,243,250"
I keep getting an nvarchar to smallint conversion error. Has anyone ever tried to do this?
View Complete Post