Actually, I can make this question MUCH simpler. Can anybody demonstrate how to parse a few values out of this document. My attempts are missing the boat somewhere. Here's what I've got:

DECLARE @doc XML

SELECT @doc = ' '

SELECT @doc.value('/OTA_HotelResNotifRQ[1]/HotelReservations[1]/HotelReservation[1]/@CreateDateTime', 'datetime')

SELECT @doc.value('/OTA_HotelResNotifRQ[1]/HotelReservations[1]/HotelReservation[1]/@CreateDateTime', 'varchar(80)')