Building XML

I create a lot of reports which have, for example, a person's
information and then associated items like expenses, goals, etc, which
are taken from a SQL database and output XML for display.

Tacking these associated items on has the feeling of being cludgy.
While I don't want to arouse the vindication of the group by pasting
ASP code, the basic gist is that I get the records of the person, and
then I tack on the expenses below the root node. The limitation to
this is that its a one-time thing--my functions don't allow for, say,
multiple people and multiple expenses. I feel this is a

I attempted to take care of this in XML by simply making an ASP file
that accepts somewhat arbitrary SQL and outputs XML, and then just
calling it remotely using XSL's document() function.