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;

Node	IDT	varVal	MyColumn
<simpleTable idt="d1" varVal="1">Some Value1</simpleTable>	d1	1	Some Value1
<simpleTable idt="d2" varVal="1">Some Value2</simpleTable>	d2	1	Some Value2
<simpleTable idt="d3" varVal="1">some Value3</simpleTable>	d3	1	some Value3
<simpleTable idt="d4" varVal="1">some Value4</simpleTable>	d4	1	some Value4
<simpleTable idt="d5" varVal="1">Some Value5</simpleTable>	d5	1	Some Value5
<simpleTable idt="r1" varVal="5">My Local Path</simpleTable>	r1	5	My Local Path
<simpleTable idt="r2" varVal="5">My documents Path</simpleTable>	r2	5	My documents Path
<simpleTable idt="r3" varVal="5">My Programs Path</simpleTable>	r3	5	My Programs Path
<simpleTable idt="r4" varVal="5">My Pictures Path</simpleTable>	r4	5	My Pictures Path
<simpleTable idt="r5" varVal="5">My videos Path</simpleTable>	r5	5	My videos Path