SQL 2000 - Retrieve ID value from XML field

• Steve Hindle-535638

  SSCrazy

  Points: 2378

  More actions

  August 18, 2008 at 3:32 am

  #94498

  (SQL 200) I have a field that I want to retrieve the BinTypeID from.

  Here is the XML:

  Does anyone know the easiest way to do this? Can these values be used in a oin so I can retrieve the description from a lookup table?

• RyanRandall

  SSChampion

  Points: 13623

  More actions

  August 22, 2008 at 8:38 am

  #861940

  Replace all instances of < with &lt; to post your XML...

  Ryan Randall

  Solutions are easy. Understanding the problem, now, that's the hard part.

• Steve Hindle-535638

  SSCrazy

  Points: 2378

  More actions

  August 22, 2008 at 8:45 am

  #861948

  Apologies. Here's the XML:

  &ltNewDataSet&lt

  &ltFormData&lt

  &ltRequestTypeID&lt1005&lt/RequestTypeID&lt

  &ltRequestTypeText&ltAdditional Bin Request&lt/RequestTypeText&lt

  &ltFormVersion&lt1.0.0&lt/FormVersion&lt

  &ltNotes&ltPLEASE DELIVER AN ADDITIONAL GREY TO THE BACK&lt/Notes&lt

  &ltEscalate&ltFalse&lt/Escalate&lt

  &ltBinTypeID&lt20&lt/BinTypeID&lt

  &ltBinTypeText&ltRecycling Bin 240 litre (grey)&lt/BinTypeText&lt

  &lt/FormData&lt

  &ltEligibilityFailure&lt

  &ltID /&lt

  &ltDescription /&lt

  &lt/EligibilityFailure&lt

  &lt/NewDataSet&lt