Finding the name

• Steve Jones - SSC Editor

  SSC Guru

  Points: 737403

  More actions

  January 19, 2017 at 8:14 pm

  #72663

  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

• Eirikur Eiriksson

  SSC Guru

  Points: 182942

  More actions

  January 20, 2017 at 12:48 am

  #1923934

  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);


• Ed Wagner

  SSC Guru

  Points: 287026

  More actions

  January 20, 2017 at 5:31 am

  #1923981

  Nice question.  Not being much of an XML expert, I learned something new.

  Tally Tables - Performance Personified
  String Splitting with True Performance
  Best practices on how to ask questions

• Revenant

  SSC-Forever

  Points: 42467

  More actions

  January 20, 2017 at 9:29 am

  #1924083

  Interesting one. Thanks, Steve!