August 27, 2003 at 2:07 am
Hi,
How do I have an XML stream which consists of multiple table? Supposed I'd like to have an XML Document like the following:
<Root>
<Customers>
<Customer id="1" name="abc"/>
<Customer id="2" name="def"/>
</Customers>
<Books>
<Book Title="Foo"/>
<Book Title="XYZ"/>
</Books>
</Root>
Using FOR XML clause, I just can get either the Customers or the Books element in one XML Document but not both of them. How to achieve that?
Thanks for any help
Hendry
September 2, 2003 at 12:00 pm
This was removed by the editor as SPAM
September 3, 2003 at 1:10 pm
Join the tables if possible. Other than that you'll have to merge the separate XML docs on the client or middle tier to get one doc. .Net lets you retrieve the tables separately, gives you some nice options for persisting.
Andy
September 7, 2003 at 10:38 pm
Hi Andy,
Thanks for the input. Anyway, Could you tell me how to Merge several XML docs, possibly using the .NET Framework. Any sample or web resource is Ok. I appreciate it much.
Thanks,
hendry
September 9, 2003 at 4:22 am
That's what I'm looking for.
Thanks a million,
Hendry
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply