FOR XML EXPLICIT

[Goran Djuranovic]

Hi all,

Is it possible to manipulate the order of child elements within a parent element?

 

For example, the following code:

Select Distinct

    1 As Tag,

    Null As Parent,

    Practice.PracticeID As [Practice!1!PracticeID!ELEMENT],

    Null As [Contact!2!LastName!ELEMENT],

    Null As [Contact!2!FirstName!ELEMENT],

    Practice.Phone As [Practice!1!Phone!ELEMENT]

From Practice

For Xml Explicit

    ... blah, blah ...

 

will always generate:

<Practice>

  <PracticeID>32</PracticeID>

  <Phone>(111) 111-1111</Phone>

  <Contact>

    <LastName>Fancy</LastName>

    <FirstName>Bob</FirstName>

  </Contact>

</Practice>

 

BUt , I want this: 

<Practice>

  <PracticeID>32</PracticeID>

  <Contact>

    <LastName>Fancy</LastName>

    <FirstName>Bob</FirstName>

  </Contact>

  <Phone>(111) 111-1111</Phone>

</Practice>

 

Thanks in advance.

Goran Djuranovic

 

[Goran Djuranovic]

OK, I figured one way I could do it is to "Union All" another "Select" statement with "Phone" element in it, only. This would put it at the end of element list, under a parent element.

 

Goran

"Goran Djuranovic" <goran.dj...@newsgroups.nospam> wrote in message news:ulKIAbqX...@TK2MSFTNGP05.phx.gbl...