Export Sql Results In XML

Hi,

Based on the "SQL Book Server Online" from MSSQL 2000 I wrote the following codes in order to export the search results in XML format.

se pubs
select
 1 as tag,
 null as parent,
 stor_id as [store!1!stor_id],
 stor_name as [store!1!stor_name],
 null as [Order!2!Ord_Num],
 null as [Order!2!ord_date]
from stores
union all
select 2 as tag,
 1 as parent,
 sa.stor_id,
 null,
 sa.ord_num,
 sa.ord_date
from sales sa
join stores st
on sa.stor_id = sa.stor_id
order by [store!1!stor_id], [Order!2!Ord_Num]
for xml explicit

The problem is that I want to results to be something like:

<stores>
   <store>
      <stor_id>6380</stor_id>
      <stor_name>Eric the Read Books </stor_name>
      <order>
         <ord_num>A2976</ord_num>
         <ord_date>1994-09-14 00:00:00.000</ord_date>
      </order>
      <order>
          <ord_num>722a</order_num>
          <ord_date>1994-09-13 00:00:00.000</ord_date>
       </order>
   </store>
   <store>
      <stor_id>7066</stor_id>
      <stor_name>Barnum's</stor_name>
      <order>
         <ord_num>6871</ord_num>
         <ord_date>1993-05-24 00:00:00.000</ord_date>
      </order>
      <order>
         <ord_num>QA7442.3</ord_num>
         <ord_date>1994-09-13 00:00:00.000</ord_date>
       </order>
   </store>
</stores>

How can I get the results in this format?

And, also, how can I export them directly into an xml file and save it on the disk?

Thank you in advance for your answers.