Need some suggestions on how to insert a tabular data in a table. we have a deal table and lets say a particular deal has 10 rows (and 25 columns). user makes some changes to one of the 10 rows, while saving all the 10 rows have to be inserted with a new version id. so everytime a new version is to be created, all 10 rows should be added to the table in one transaction.
whats a good way to do that...xml is one option...what else?