How to read a xml in SQL Server 2005?

[zalex]

I have this query\[code\]WITH XMLNAMESPACES (DEFAULT 'http://www.w3.org/2005/Atom') select cast(idsku as int) idsku,cast(entregado as int) entregado from #final1 final FOR XML AUTO, ROOT ('clientesxml'), ELEMENTS \[/code\]this return \[code\]<clientesxml xmlns="http://www.w3.org/2005/Atom"> <final> <idsku>191</idsku> <entregado>159</entregado> </final></clientesxml>\[/code\]My question how do I create a stored procedure which reads the XML returned and converts it into a \[code\]#tempTable\[/code\] ?