So going back to http://benchmarkitconsulting.com/colin-stasiuk/2009/01/14/parsing-xml-into-a-table-structure-possible/ Can it be done? Yes… it’s not pretty but yes it can be done. I emailed this to Brent Ozar to see if he was an XML guru as we had gone back on forth on Twitter about whether or not it’s possible. He pointed me to StackOverflow and 1 [...]
Posts under ‘XML’
Parsing XML into a Table Structure… possible?
Well let me elaborate a bit. The use case (which I’m now hating R.K. for bringing up cause I wont let it go now LOL ) where this applies is…. “I want to insert into a temp table the results of a dynamic sql statement” The caveat being this has to be done WITHOUT knowing [...]
