• I have used XML to insert multiple rows using a SP for years now. I certainly see the benefits. There is a huge performance boost when inserting data aggregations that need to be placed in multiple related tables. You just hand over a big chunk of XML to the SP, and it can handle all the inserts within a single transaction. The code is not that complex. It usually just boils down to a set of 'INSERT INTO ... SELECT FROM ..' statements.