想达到以下效果，该如何安排表？查询语句怎样写？先谢了！
<?xml version="1.0" encoding="UTF-8"?>
<Document xmlns:xsi="http://www. xmlns:xsd="http://www. SN="000000000000" License="20081018-594044" Version="2.10">
  <Events>
    <Event Name="SalesWareHouseOut" MainAction="WareHouseOut">
      <DataField>
        <Data Code="81003350050092884560" Actor="1111" ActDate="2011-04-17"/>
        <Data Code="81003350050092875389" Actor="1111" ActDate="2011-04-17"/>
        <Data Code="81003350050092860920" Actor="1111" ActDate="2011-04-17"/>
      </DataField>
    </Event>
  </Events>
</Document>


我用以下查询
select 'http://www.' as 'xmlns:xsi',
       'http://www.' as 'xmlns:xsd',
       '000000000000' as SN,'20081018-594044' as License,'2.10' as Version,
(select
      (select 'SalesWareHouseOut' as name,'WareHouseOut' as MainAction,
              (select
                     (select * from Data
                         for xml auto,type)
                 for xml raw ('DataField'),type)
          for xml raw ('Event'),type)
for xml raw ('Events'), type)
for xml raw ('Document'),type

得到了如下结果：
<Document xmlns:xsi="http://www. xmlns:xsd="http://www. SN="000000000000" License="20081018-594044" Version="2.10">
  <Events>
    <Event Name="SalesWareHouseOut" MainAction="WareHouseOut">
      <DataField>
        <Data Code="81003350050092884560" Actor="1111" ActDate="2011-04-17"/>
        <Data Code="81003350050092875389" Actor="1111" ActDate="2011-04-17"/>
        <Data Code="81003350050092860920" Actor="1111" ActDate="2011-04-17"/>
      </DataField>
    </Event>
  </Events>
</Document>

但 <?xml version="1.0" encoding="UTF-8"?> 该怎么办？
另：如何在存储过程中将结果另存为文件？




[ 本帖最后由 jsntxzl 于 2011-9-7 09:14 编辑 ]