STRUGGLING with a Stored Procedure Parameter Issue 1

[checkai]

Here's what I have....

a SP that takes 4 variables...one being a description field which could have apostrophe's in it....another being a string that looks like this
@list = '34,434,343'

my sp uses the code where wipID in (@list)

however wipID is an int...the list is actually an array in .NET that gets converted to a string...

I get a cannot convert to type INT error....

Any suggestions would be amazing...

DLC

 

[sunila7]

Hi,

Use dynamic SQL to do this.. Have a look at FAQ3132

Declare @SQL Varchar(7000)
Declare @InList varchar(200)
SET @InList = '34,43,343,34'

SET @SQL = 'SELECT * from TBL where wipID IN (' + @InList + ')'

exec (@SQL)

As for Apostrophe in a field, replace it with 2 single quotes. for eg:


Declare @w varchar(200)

set @w = 'Brain''s'

print @w

This will print Brian's in QA window.

Sunil

 

[ramone109]

As long as your not using wipID in any mathematical expressions, couldn't you just convert wipID to a string after its value has been established, and then use it in the IN expression against @list?