Data into XML

Hi, I have a select statement which returns data in sql server 2000, however i need to convert this into an XML document. I have the option of doing it via VB6 however, i do not want to do this as there will be up to 50, 000 records conveting, there must be a simple way just to convert it on the server.

Any ideas appretiatedJust bumping this back up the chain|||Not too sure if this is what you are looking for.

Dim comp As New Data.DataSet

After reading all the data required into your data adapter ect.

Use the final coding to write to an xml file in the spcified location:

comp.WriteXml("C:\xml\TestXml_Complete.xml")

\TestXml_Complete.xml is the name of the xml you will be saving...