Posted by chippy on 05/17/06 13:31

Thank you for your suggestion. However, running your query gives me
this:

<message msgID="195">
<set namelong="STUFF HERE" nameshort="STUFF" />
</message>
<message msgID="195">
<set namelong="MORE STUFF" nameshort="M STUFF" />
</message>
<message msgID="195">
<set namelong="TESTING 123" nameshort="TEST" />
</message>

Thanks

• Next in forum: Re: create table with recursive relationship
• Prev in forum: Re: purpose of OUTPUT keyword in sql server
• Thread view: Re: Putting attribute on root node using FOR XML PATH

[Reply to this message]