My requirement is: Have SSRS reports with many parameters ( flag, single and multi-value). I need to take each parameter and pass it to a stored procedure to be stored in a table ( ParamName, ParmValue ). Since I do not know what parameters I will have in a given report, I would like my stored procedure be able to accept a dynamic list of parm names and values. I found examples of what to do to pass one multi value parameter and use a table value data type but I could not find anything about what I need. As an example:
Would like one stored procedure that would accept both sets of parms in some kind of dynamic way.
Any thoughts would be greatly appreciated.