Passing an array or DataTable into a stored procedure

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.