G[/code][/code][/code]Squared (7/15/2009)

---

Take a look at this, see if you can work with it:

declare @String varchar(max), @XML XML;

select @String =

'<Seq>

<MyElement Number="12">

<InnerElement>

<simpleTable idt="d1" varVal="1">Some Value1</simpleTable>

<simpleTable idt="d2" varVal="1">Some Value2</simpleTable>

<simpleTable idt="d3" varVal="1">some Value3</simpleTable>

<simpleTable idt="d4" varVal="1">some Value4</simpleTable>

<simpleTable idt="d5" varVal="1">Some Value5</simpleTable>

</InnerElement>

<InnerElement>

<simpleTable idt="r1" varVal="5">My Local Path</simpleTable>

<simpleTable idt="r2" varVal="5">My documents Path</simpleTable>

<simpleTable idt="r3" varVal="5">My Programs Path</simpleTable>

<simpleTable idt="r4" varVal="5">My Pictures Path</simpleTable>

<simpleTable idt="r5" varVal="5">My videos Path</simpleTable>

</InnerElement>

</MyElement>

</Seq>'

select @XML = @String;

select

Node,

Node.value('(/simpleTable/@idt)[1]','char(2)') as IDT,

Node.value('(/simpleTable/@varVal)[1]','varchar(100)') as varVal,

Node.value('(/simpleTable)[1]','varchar(100)') as MyColumn

from

(select X.Y.query('.') as Node

from @XML.nodes('Seq/MyElement/InnerElement/simpleTable') X(Y)) Z;

The result I get from this looks like it could easily be concatenated into what you want.

Does that help?