Thanks!

Thanks for the help - I thought the solution would be simpler... :S

Sample data:

table X

ID Name Value

AXN E1...

Yes - still, I wanted to have

<top_element>

<name>A</name>

<value>B</value>

</top_element>

but no cigar...

Sure - but bear in mind: my original reason for posting this was doing this in a single query. My "noobness" might show in the solution I found... 😀

select

S_T.[Id]as Id,

S_T.[Moment]as...

Thanks for all your input! I have found a solution to my problem!