/*
	You will notice that the result does not have a ROOT element.
	A corret XML document/fragment should always have a ROOT element.
	Let us have this added by using the ROOT keyword. 
*/

SELECT OrderNumber, ItemNumber, Qty FROM OrderDetails FOR XML AUTO, TYPE, ELEMENTS, ROOT

/*
OUTPUT:

<root>
  <OrderDetails>
    <OrderNumber>00001</OrderNumber>
    <ItemNumber>A001</ItemNumber>
    <Qty>10</Qty>
  </OrderDetails>
  <OrderDetails>
    <OrderNumber>00001</OrderNumber>
    <ItemNumber>A002</ItemNumber>
    <Qty>20</Qty>
  </OrderDetails>
  <OrderDetails>
    <OrderNumber>00001</OrderNumber>
    <ItemNumber>A003</ItemNumber>
    <Qty>30</Qty>
  </OrderDetails>
</root>
*/