/*
	By default, SQL SERVER returns the values as attributes. 
	Some times you might need the values as nodes. Use the
	ELEMENTS keyword for that. 
*/

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

/*
OUTPUT:

<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>
*/