convert to xml

[Imran Ashraf]

Hi,

I have this query and i want to prduce xml file in specific format:

Select payroll,forename, surname from staff;

xml format required:

<?xml version="1.0" encoding="UTF-8"?>
<ImportTask xmlns="http://inplace.quantumit.com.au/import/version_1_0/"; xmlns:i=
"http://www.w3.org/2001/XMLSchema-instance">;
<StaffMembers>
<Staff>
<Payroll>0123456</Payroll>
<Forename>Steve</Forename>
<Surname>Smith</Surname>
</Staff>
<Staff>
<Payroll>098765</Payroll>
<Forename>Alex</Forename>
<Surname>James</Surname>
</Staff>
</StaffMembers>
</ImportTask>


How can i write the query to produce this xml format?

Thanks