I am writing a stored procedure that will return an xml document.
The document contains 3 sections.
I am thinking that i would first create the three different sections with their own TSQL and then combine them into the final xml document.
Is this OK? And if so how would i modify my xml document to insert the three sections between the root tags?
Using SQL Server 2008.