Report Portal

ReportPortal
ReportPortal
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 ReportPortal General Forum
 Report Portal General Issues
 SQL Server Stored Procedure for Multi-Select		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

dhewes

USA
2 Posts
Posted - 06/06/2016 :  11:55:43  Show Profile  Reply with Quote
How would I create a SQL Server stored procedure parameter for multi-select filter?

Dave

admin

1651 Posts
Posted - 06/06/2016 :  12:44:28  Show Profile  Reply with Quote
The stored procedure is used in the report or the multi-select filter?
Go to Top of Page

dhewes

USA
2 Posts
Posted - 06/06/2016 :  12:55:00  Show Profile  Reply with Quote
The report.

Looks like it is passing back something like the following


exec [usp_someSP_ByID] ('123', '456', '789')
Go to Top of Page

admin

1651 Posts
Posted - 06/06/2016 :  13:16:40  Show Profile  Reply with Quote
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
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
ReportPortal © 2000-2002 Snitz Communications Go To Top Of Page