It has to be inserted as two rows in order tables. There is no business validation that happens in the data intake operation. The business validations are done by a...

Actually we are using an ORM tool (nhibernate) to persist data in multiple tables (order and orderdetails). We pass the object collection to nhibernate methods to persist the data. The...

Thanks a lot. The code snippet provided by you definitely helps to insert data without using OPENXML.

The approach relies on having a unique name across orders. In one of the...

This is the sample XML

"root"

"order name="order1" description="order2"

"orderdetails item="item1" state="AL"

"order"

"root"

and there could be around 100 to 200 orders

and table structure is like this

Order (Order_id IDENTITY, Name varchar, description varchar)

Orderdetails...