comma delimited sproc?
in a situation where you have to loop through dozens of inserts to a database, would you rather:
I'm not sure why you say option 2 requires multiple trips to the connection pool. If you hold onto the connection and call the proc multiple times with the same connection that is a non issue. Sure there is more network overhead of calling the proc multiple times and a bit more server overhead but these are typically dwarfed by any time spent by the server actually doing work. Generally I prefer not to do any string parsing (the commas) inside database code, it's just uglier and typically proper error handling in this situation ends up being more complex.
Fog Creek Home