THANK YOU!:-P

I WILL TEST IT.

Thank you Lutz for providing a good solutioin with cte,unpivot and sunquey to build two nodes. According to your code, I finished the SP to generate to the whole xml...

Thanks,but cannot generate the specific xml format with one root segment ('ResultSet') and two child segment ('Master','DetailS') for every table record.

<ResultSet>

<Master>

<RowMaster id="1">

<col name="KHID">4065479</col>

<col name="DHSLRID">134519</col>

<col name="BZ">TEL</col>

<col name="FWCPDM">729</col>

<col name="LDSJ">2011-01-03 08:46:44</col>

<col name="SH">2011</col>

<col name="GDDH">3641613-803</col>

<col...