/*
	The simplest way to return values in XML format is to use the keyword
	FOR XML with AUTO. 
*/

SELECT OrderNumber, ItemNumber, Qty FROM OrderDetails FOR XML AUTO

/*
OUTPUT:

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