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

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

select @String =

'

Some Value1

Some Value2

some Value3

some Value4

Some Value5

My Local Path

My documents Path

My Programs Path

My Pictures Path

My videos Path

'

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?