Posted by chippy on 05/17/06 15:57

Thanks again for your reply. I think the problem here is that the
relationship between the msgset table and the settable is many-to-many.
So, the sample data would look like this:

declare @settable table(msgid int,namelong varchar(20),nameshort
varchar(10),setid int)
insert @settable(msgid,namelong,nameshort,setid) values(195,'STUFF
HERE','STUFF',1)
insert @settable(msgid,namelong,nameshort,setid) values(195,'MORE
HERE','M STUFF',2)
insert @settable(msgid,namelong,nameshort,setid) values(195,'TESTING
123','TEST',3)
declare @msgset table(msgid int,setid int)
insert into @msgset(msgid,setid) values(195,1)
insert into @msgset(msgid,setid) values(195,2)
insert into @msgset(msgid,setid) values(195,3)

This is an important detail, I'm sorry I left it out.

Any help would be much appreciated-- it seems like there should be a
simple solution to this.
Thanks.

• Next in forum: Re: Putting attribute on root node using FOR XML PATH
• Prev in forum: Compare databases between 2 SQL servers
• Thread view: Re: Putting attribute on root node using FOR XML PATH

[Reply to this message]