|
|
Posted by chippy on 05/17/06 16:12
OK, I figured out a solution:
select
m.msgid '@msgID',
(
select st.namelong '@namelong',
st.nameshort '@nameshort'
from settable st, msgset ms
where st.setid = ms.setid
and ms.msgid = 195
for xml path('set'),type)
from
message m
where m.msgID = 195
for xml path('message'), type
I joined another table that created a one-to-many against the msgset
table. That seems to keep the root node down to one. Thanks for
pointing me in the right direction.
--chip
Navigation:
[Reply to this message]
|