Nice solution, I was actually looking for a better way to parse parameter values from reporting service (multi-valued) over to a procedure. And until now I only had the loop-function....

with the A,B,C,D,E example, the select distinct syntax would be better imho.

Okey that sounds as a good idea, but 2 things:

1. Can Bulk insert be executed as Stored Procedure?

2. How to set permission in the stored procedure?

What is the closest I can get? And what will the user not be able to with these permissions?

Tx btw 😉