I have a stored procedure with a select query

Question

Dear Sir Can i get a solution for my problem described below ? I have a stored procedure with a select query like Select custcodemob 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

Piyush Pansuriya · Answer

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 custcodemob from tableCustomer where custcode in ('+ @custcode+')' EXEC( @Full_Query) END Now pass value in parameter like '101102' from vb.net.

anil john · Answer

Thank you

Vithal Wadje · Answer

your @custcode variable must be int.

Murugesh P · Answer

A part of your query is Static( Select custcodemob 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.