I need a .XML file from MS SQL

[juresti]

I had a database in access I created a query and exported to xml because I need to use it for a calendar. Now the database is in MS SQL I have the access query as a view in ms sql and I need this to produce an XML file I can not figure this out. Can anyone help? I am very upset.

I need a .xml file for a javascript calendar am I going about this the wrong way?

[David_Powers]

The following page describes how to create XML from a database query: http://labs.adobe.com/technologies/spry/samples/utils/query2xml.html. The ASP solution is at the bottom of the page.