I don't think that there is any way to pass an array into a stored procedure. I would have joined the array into a string using the Join-function and then splitting it up again in the sp using the charindex-function.

Maybe it's the way you have done it today?

Magnus