Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

"For XML Explicit" queries doesn't work with more then 1 element

Status
Not open for further replies.
PLV

PLV

Programmer
Apr 29, 2001
15
0
0
US
I have a query that returns a perfect xml for one record. It looks like
<People>
<Artist>
<Info><TheInfo ddd></info>
<otherInfo><TheInfo2 eee></otherInfo>
<MoreInfo><TheInfo3 fff></MoreInfo>
</Artist>
</People>
I've done this with parent tags. I think I've followed all the steps correctly but when I have more then 1 artist in my query it returns all the information append to the last artist. It's like it can't associate the info to the artist.

Is there a way to do it, can you give a example of the query I need to do this correctly with more then I row?

Thx alot,
PLV




 
Status
Not open for further replies.

Similar threads

grnzbra
  • Locked
  • Question
Is &quot;IF EXISTS()...&quot; better than &quot;IF (SELECT COUNT...) &gt; 0&quot;
Replies
4
Views
708
gmmastros
gmmastros
grnzbra
  • Locked
  • Question
SELECT TOP 1 of Each of a Group
Replies
5
Views
90
grnzbra
grnzbra
gussy81
  • Locked
  • Question
Decimal Datatype with negative value
Replies
5
Views
255
Chris Miller
Chris Miller
grnzbra
  • Locked
  • Question
Why the &quot;WITH&quot; Format 1
Replies
12
Views
108
TamarGranor
TamarGranor
Jago11
  • Locked
  • Question
When to use 1=1 logic 1
Replies
7
Views
85
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top