Hello
I have no XML experience. Can u tell me how to perform the following:
1. Generate XML document:
I am running a few queries on server X having database A . How can I convert this into an XML document?
2. Load to another database B on server Y: Now once I have the XML document, I would like to load the data into database B.
I'll use this to generate some reports.
I would really appreciate if you could layout detailed procedure for me.
Thanks in advance.