Take a look at this very interesting article by Erland Sommarskog which gives a number of detailed descriptions along with performance measurements on how to pass an array to a stored procedure. This is extremely useful for creating a dynamic WHERE clause.
[Update: updated article link...]