kamran

Look at using XML. Your application can build an XML document with
multiple instances of the rows you want to insert/update and that can
be passed as a parameter to the store proc. The store proc then uses
XML specific SQL to read the XML and from there insert and update your
table.

Hope this helps


Duncan