How to pass multiple values to sql server store procedure? And how to use it in SSRS?

preview_player
Показать описание
This video demonstrates how to pass multiple values to a sql server store procedure. It discusses multiple approaches to solve this issue. Also, it displays how to use a store procedure within a SSRS report and how to pass multiple values from the report to the store procedure.

Store Proc, Function and test script:
Рекомендации по теме
Комментарии
Автор

THANK YOU SOOOO MUCH.. I spent 5 hours and my brain was completely stuck, then I took help from the video and XML one did work for the very first time... thank you again for saving my time :)

hirakde
Автор

Will the 3rd Option(creating a function) work also with integer parameters?

bck
Автор

will it work for multiple parameters with multiple values?

seshagiriraokudaravalli