I've been searching for an answer for some time and can't seem to find one. When using FOR XML EXPLICIT with two tables & UNION ALL, how do I add a root element in my sproc? As in if I just want to wrap my XML with a foo root element. My procedure is creating multiple root level elements even though I for the most part have the xml formed to my liking. Probably not the best place to ask the question, but I'm here now & you seem to like dealing with XML in sql. cheers