Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Development Tools
 Reporting Services Development
 How to pass multi parameter to dynamic sql

Author  Topic 

ettubrute
Starting Member

1 Post

Posted - 2008-08-27 : 08:06:44
declare

@tsql as varchar(max)



SET

@tsql ='select bla,bla from bla where NAME IN (' + '''' + @employees + '''' + '))'



this work I have passed single parameter (for example , 'Ali')

but if I have passed a list of parameters to a multivalue parameter in a SQL Report. (for example : 'Ali','Veli')
this doesnt work
(Note:I select this parameters from Combobox in my report)
   

- Advertisement -