| T O P I C R E V I E W |
| dhewes |
Posted - 06/06/2016 : 11:55:43
How would I create a SQL Server stored procedure parameter for multi-select filter?
Dave |
| 3 L A T E S T R E P L I E S (Newest First) |
| admin |
Posted - 06/06/2016 : 13:16:40
What kind of parameter does your stored procedure have (varchar, table)?
In case your stored procedure accepts table parameter, you can pass it like this:
declare @list table (fname varchar(20));
insert into @list
select fname from employee where fname in '::1';
exec [usp_someSP_ByID] @list |
| dhewes |
Posted - 06/06/2016 : 12:55:00
The report.
Looks like it is passing back something like the following
exec [usp_someSP_ByID] ('123', '456', '789')
|
| admin |
Posted - 06/06/2016 : 12:44:28
The stored procedure is used in the report or the multi-select filter?
|
Report Portal
