Loading

I have a stored procedure with a select query

anil john

12y1.3k

Dear Sir,

Can i get a solution for my problem described below ?

I have a stored procedure with a select query like

Select custcode,mob from tableCustomer where custcode in (@custcode)

here @custcode declared as varchar(50)

from a vb.net page am calling this procedure with parameter strCode with value as
'101','102' but not getting the result

when directly executing the query with these custcodes in sql am getting the results

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

anil john11y ago
Thank you
0
Vithal Wadje11y ago
your @custcode variable must be int.
0
Murugesh P11y ago
A part of your query is Static(Select custcode,mob from tableCustomer where custcode in) and another part is dynamic(@custcode) that causes the problem. Either you have to convert your select statement to static and execute it as a whole or you have to get the cust code in some temporary table and use 'in' operator.
0
Piyush Pansuriya12y ago
Hi Anil,

As per your problem, you have to use string query in storeprocedure like this:

BEGIN
DECLARE @Full_Query NVARCHAR(Max)
SET @Full_Query= 'Select custcode,mob from tableCustomer where custcode in ('+@custcode+')'
EXEC(@Full_Query)
END

Now pass value in parameter like '101,102' from vb.net.
+1