January 19, 2017 at 8:14 pm
Comments posted to this topic are about the item Finding the name
January 19, 2017 at 9:48 pm
This was removed by the editor as SPAM
January 20, 2017 at 12:48 am
Thanks for the simple question Steve.
😎
Quick pointer, use the text() function to bypass the implied XML reconstruction for the output,
SELECT r.value('local-name(.)','VARCHAR(100)') AS Slot,
r.value('(./text())[1]','VARCHAR(100)') AS Team
FROM @data.nodes('/Playoffs/AFC/TopSeedQuarter/*') AS x(r);
January 20, 2017 at 5:31 am
Nice question. Not being much of an XML expert, I learned something new.
January 20, 2017 at 9:29 am
Interesting one. Thanks, Steve!
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply