Using attributes and values together

• Absinthe-428914

  Mr or Mrs. 500

  Points: 514

  More actions

  March 30, 2009 at 8:10 am

  #72000

  When using "for xml explicit" I am seemingly able to get whatever I want. However, I am missing how to do one thing:

  I would like to get something like this:

  So far I have figured out how to get:

  and

  and even:

  but NOT

  I know I must be missing something easy, but for the life of me can't tell what...

• Absinthe-428914

  Mr or Mrs. 500

  Points: 514

  More actions

  March 30, 2009 at 8:28 am

  #968385

  I couldn't figure out how to remove the previous post. The answer to which is found

  http://www.sqlservercentral.com/articles/ADO/article4/516/

  However, my post didn't display correctly anyway because of all the angle brackets and such.