Shredding XML

Tim Peters introduces us to shredding multi-level XML:

The below XML has data nested in different levels that requires the nodes method to join them together. The nodes method accepts a XML string and returns a rowset. That rowset can then be used with CROSS APPLY to effectively link your way down.

nodes (XQuery) as Table(Column)

The tabular format I need requires data from 3 different levels of this XML gob and I need to wade through 5 “tables” to get there.

Shredding XML is something you occasionally need to do.

Related Posts

T-SQL Tuesday Roundup

Rob Sewell has this month’s T-SQL Tuesday roundup: But anyway, on to the TSQL2sDay posts Ah #tsql2sday – It seems you have gone a little bit posh! pic.twitter.com/bPqu4p1w7D — Rob Sewell (@sqldbawithbeard) September 12, 2017 What a response. You wonderful people. I salute you with a Rimmer salute Read on for an amazing 34 entries.

Read More

Using RAISERROR For Debug Info

Doug Lane exhorts people to use RAISERROR instead of PRINT when printing messages: It wasn’t until a few years ago, when I started contributing to the First Responder Kit at Brent Ozar Unlimited, that I noticed every status message in the kit scripts was thrown with something other than PRINT. Strange, I thought, since those scripts like […]

Read More

Categories

January 2016
MTWTFSS
« Dec Feb »
 123
45678910
11121314151617
18192021222324
25262728293031