Can anyone tell me how I could do the following within a SQL stored procedure?
The stored procedure recieves certain values which are used as part of a query and I want to be able to output this information to an XML file in a folder on my system.
If the XML file is already there I'd like to be able to append the new information to it, otherwise create a new file and populate it
with the data. I think this should be fairly easy to do but my experience with XML, especially through SQL 2000 is limited.
Thanks in advance,
Stuart
The stored procedure recieves certain values which are used as part of a query and I want to be able to output this information to an XML file in a folder on my system.
If the XML file is already there I'd like to be able to append the new information to it, otherwise create a new file and populate it
with the data. I think this should be fairly easy to do but my experience with XML, especially through SQL 2000 is limited.
Thanks in advance,
Stuart
