Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2011
    Posts
    4

    Post Unanswered: School Assigment

    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>

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    and what have your tried so far?
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Aug 2011
    Posts
    4

    Post Hi friend

    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>

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    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
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •