IN Operator iisue in proc

Question

how to export ssrs rdl report to excel in csharp programically. how to send data comma seperated to sql porcedure for IN Operator. for ex-- if i have (ans) then it replace in IN operaator with ('a''n''s')

Puneet Kankar · Answer

Please check below link maybe this is helpful for you. https://stackoverflow.com/questions/19840813/using-the-in-operator-to-filter-in-reporting-services

Anil Jha · Answer

Try to replace this approach IF OBJECT_ID( 'tempdb..#tempTable' ) IS NOT NULL DROP TABLE #tempTable; CREATE TABLE #tempTable (number int ); DECLARE @TEXT varchar ( max ) = '1172544466788' ; DECLARE @InsertStatement varchar ( max ) = 'insert into #tempTable values (' + REPLACE (@TEXT ''  ')(' )+ ');' ; EXEC (@InsertStatement); SELECT * FROM #tempTable; First convert your comma separated string to table and then use into IN operator.