Build a procedure that takes as argument an order to the following XML format and adds the order data in the respective tables.

<Order>

<OrderData OrderID="10248" OrderDate="1996-07-04T00:00:00" EmployeeID="5" CustomerID="VINET">

<OrderItem ProductID="11" Quantity="12" UnitPrice="14.0000" />

<OrderItem ProductID="42" Quantity="10" UnitPrice="9.8000" />

<OrderItem ProductID="72" Quantity="5" UnitPrice="34.8000" />

</OrderData>

and what have your tried so far?

I have just this question for home work,and how can i make this procedure,that we take at this result.

Build a procedure that takes as argument an order to the following XML format and adds the order data in the respective tables.

<Order>
<OrderData OrderID="10248" OrderDate="1996-07-04T00:00:00" EmployeeID="5" CustomerID="VINET">
<OrderItem ProductID="11" Quantity="12" UnitPrice="14.0000" />
<OrderItem ProductID="42" Quantity="10" UnitPrice="9.8000" />
<OrderItem ProductID="72" Quantity="5" UnitPrice="34.8000" />
</OrderData>

as per post #2
what have you tried
what have you got problems with

I can't speak for others but I don't do school/uni/home/coursework
I'll help where I can but I wont do