I am doing a project where I am going through my company's employee database and then extracting the people who have birthdays for the next week. When I have done that, I want to export that information into an XML file, to be read by a web-based flash applet. The SQL code will be used to create a stored procedure and run on a daily basis as part of a job.
The basic XML format should be as follows:
<birthdate id="01" date="10/12/2004">
<birthdate id="02" date="10/13/2004">
Thank you in advance for your expert help!