FOR XML EXPLICIT allowes you to return your results in a structure specifically defined by you. It is much more powerful and richer than FOR XML AUTO and FOR XML RAW.
You might want to give it a shot.
What I hear I forget, what I see I remember, what I do I understand