Posted by Erland Sommarskog on 12/11/05 18:33

coosa (coosa76@gmail.com) writes:
> Ok, Erland; it seems I will bother you more! :-) Sorry
> Each Category is displayed 4 times, and i tried to use the keyword
> DISTINCT but it seems XML doesn't support it.
>
> How can I overcome this problem first?

Could you post:

1) CREATE TABLE statements for the table?
2) INSERT statements with the sample data?

It's a little difficult to say something without anything to play around
with.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: Nested Nodes in XML from a table
• Prev in forum: Re: Nested Nodes in XML from a table
• Thread view: Re: Nested Nodes in XML from a table

[Reply to this message]