Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Making a table out of a list

By Mark Thompson-296518,

The UDF will allow you to define a multi-valued parameter in reporting services (there are lots of other uses as well), and pass that parameter into a stored procedure.

Within the stored procedure you would use it like this:

(@strMy_User_ID_List is the passed parameter)

select *

from tblUsers

where numUser_ID in

(

select *

from dbo.dbo.fnSYS_Split_Comma_Separated_List_Of_Integers_To_Integer_Table(@strMy_User_ID_List)

)

Total article views: 965 | Views in the last 30 days: 2
 
Related Articles
FORUM

Parameter to Parameter

Parameter Values

FORUM

Parameter Dependency

Parameter Dependency

FORUM

Parameter issue

Parameter issue

FORUM

Multiple parameters

Multiple parameters

FORUM

Multiple report parameters

Parameter dependency

 
Contribute