http://www.codeproject.com/cs/database/PassingArraysIntoSPs.asp
Passing an array or DataTable into a stored procedure
By Gareth Edwards
This article describes how to pass the equivalent of an array, into a stored procedure, showing a number of different data types. This technique doesn't have the size limitations that a number of other techniques suffer from.