Not sure what you have in the way of bind variable types in SQL Server, but in Oracle the standard way to to that (ie massive batch load) is to create a stored procedure that uses a 'forall' construct to bypass the SQL layer for a bound array of input values, and call that stored procedure with an array of bind variables.

rdfield

msg me for an example if req'd