riaan-777462 (10/26/2012)

---

Hi There,

I'm quite inexperienced in returning XML from SQL and have only been using single tables to return normal XML in the past.

Now, however, I need to return multiple tables (related or unrelated) in a single XML File for Exporting to another program.

Something like:

SELECT * FROM Products

SELECT * FROM Colours

SELECT * FROM Sizes

FOR XML AUTO, ROOT, ELEMENTS

Obviously the UNION operator is not going to work here so how would I need to write my T-SQL statement to return the following XML Hierarchy?

<root>

<Products>

<...>

</Products>

<Colours>

<...>

</Colours>

<Sizes>

<...>

</Sizes>

</root>

Any help will be appreciated. I've scoured the internet using keywords I think would return some result but, alas, clearly I'm not using the right keywords 🙂 so I'm hoping someone could point me in the right direction or perhaps even be so kind as to post the solution and save me from forced medical early retirement...

Thanks in advance.

Kind Regards,

Riaan