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 do a store procedure, which reads the xml returned and convert itin a #tempTable ?
how to read a xml in sql 2005?
- Thread starter kanato
- Start date