T-SQL FOR XML EXPLICIT

An excellent example of producing well formatted and structured XML direct from SQL where a non-tree structure is in use. I have used this to get a complex series of document information out in a specific format.

• http://msdn.microsoft.com/en-us/library/ms189068.aspx