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