Stored Procedure Performance when passing in mutli-values from a SSRS Report

Rather than using the function directly in a query, save the values into a temp table and use the tepm in the query.

But most of all, make sure that there are good indexes for your query.

---

Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se