how can we write a query and pass multi value parameters to stored procedure in the report? To exec a procedure we simply write

Exec MyStoredProcedure

to exec a stored procedure we need to pass parameters. I can do Exec MyStoredProcedure IN (@ParamList)

I have gone through this thread conversations however, I am not able to make out when to use Split function and how to use.

In dataset, which query I need to write to exec a stored procedure with multi value parameters.