XML AUTO Parent or child?



If I have a code like:



SELECT FullName, Country, OrderId, OrderDate, SaleAmount
FROM Orders
JOIN Customers ON Orders.CustomerId = Customers.CustomerId
WHERE Customers.CustomerId = 12345
FOR XML AUTO


It generates something along the lines of:



<Customers FullName="Bob" Country="Canada">
<Orders OrderId="1" OrderDate="2014-02-02" SaleAmount="1000.00"/>
<Orders OrderId="2" OrderDate="2014-06-08" SaleAmouont="450.00"/>
</Customers>


But what if I want to generate an XML like:



<Orders OrderId="1" OrderDate="2014-02-02" SaleAmount="1000.00">
<Customers FullName=.../>
</Orders>


What do I need to change?


No comments:

Post a Comment