I have an existing db table for which I would like to generate an XML
representation. The table is already hierarchcal in nature ...
it would seem as though I'm almost there (to the "universal table") simply
by the design of the table. However, SQL Svr books online seems to suggest
that each nested element should have a different tag number, and the way I
understand it, the tag number ties directly to an element. Therefore, how
do I go about building the query for a proper universal table format???
I'm to the point now, to where I can return a more flat XML representation
and simply transform it via XSLT upon receipt. I would like to take more
advantage of SQL Svrs XML functionality, however, if I can.