SQL Server doesn't support array structures. If there's a finite number of parameters you could supply them directly. I think a store procedure can have a maximum of 1024 parameters (you should check that number).

Another option would be to create a temporary table, fill it, and then have the stored procedure reference it.

-Mike