How to Join XML | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

How to Join XML

Hi, all
I have 4 stored procedure. 4 procedures are return xml format.
how to join 4 procedure.
eg.
procedure 1:
<Root>
<Company data="1">
<Company data="2">
</Root>
procedure 2:
<Root>
<Customer data="1">
<Customer data="2">
</Root> procedure 3:
<Root>
<Emp data="1">
<Emp data="2">
</Root> procedure 4:
<Root>
<Sal data="1">
<Sal data="2">
</Root>
i want join this 4 procedure and produce like this
<Root>
<Company>
<Root>
<Company data="1">
<Company data="2">
</Root>
</company>
<customer>
<Root>
<Customer data="1">
<Customer data="2">
</Root>
</customer>
<Emp>
<Root>
<Emp data="1">
<Emp data="2">
</Root>
</Emp>
<Sal>
<Root>
<Sal data="1">
<Sal data="2">
</Root>
</Sal>
</Root> How it is possible? Thanks
S. Ramesh
Hi
i got the ans
select ‘<Root>’
select ‘<Company>’
exec procedure1
select ‘</company>’
select'<customer>’
exec procedure2 select ‘</customer>’
select ‘<Emp>’
exec procedure3
select ‘</Emp>’
select ‘<Sal>’
exec procedure4
select ‘</Sal>’
select ‘</Root>’
Thanks
S. Ramesh
]]>