I am sorry for any confusion. When I load the xml file using the Active X script above it creates (x) number of records in the database table but all...

No that did not work for me either with the AUTO. It added stuff I did not want to the XML

Most of the vendors I supply data feeds to take...

Grant when I run your query I get this error

Msg 421, Level 16, State 1, Line 1

The xml data type cannot be selected as DISTINCT because it is not comparable.

okay I did that and it worked. Using my working example

SELECT DISTINCT F.LocalID as "@ID"

, (SELECT x.ItemUrl

...

This may help for all of those trying to help (much appreciated)

create table foo

(

localID int,

itemurl varchar(30),

photoSeq int

)

insert into foo

(localID,itemurl,photoSeq)

Values

(1,'http://mysite.com/1.jpg',1)

insert into foo

(localID,itemurl,photoSeq)

Values

(1,'http://mysite.com/2.jpg',2)

insert into foo

(localID,itemurl,photoSeq)

Values

(1,'http://mysite.com/3.jpg',3)

SELECT DISTINCT LocalID as "@ID"

, ...

This did not work for me. The output as far as the escpaed signs were corrected but the list of items came out wrong, where as it created...

Anybody? I have been searching the web for a solution and can not find anything.