declare @hdoc int exec sp_xml_preparedocument @hdoc output, N' <Root> <BookingList> <Booking> <BookingRef>HBD-71443</BookingRef> <BookingDate>09-27-11</BookingDate> <DepartureDate>10-22-11</DepartureDate> <ReturnDate>10-25-11</ReturnDate> <DebtorID>0001HAY</DebtorID> <DebtorName>Hays Travel</DebtorName> <BranchID>073</BranchID> <GrossPrice>162.77</GrossPrice> <NettPrice>131.84</NettPrice> <Commission>24.42</Commission> <CommissionVAT>4.88</CommissionVAT> <Deposit>0.00</Deposit> <CardPayment>0.00</CardPayment> <CashPayment>0.00</CashPayment> <ChequePayment>0.00</ChequePayment> <TotalPayment>0.00</TotalPayment> <Outstanding>133.47</Outstanding> <BalanceDue>09-22-11</BalanceDue> <LastModified>02-15-12</LastModified> <SourceCode>Agent Booking</SourceCode> <ProductType>ACC</ProductType> <ABTA>L8037</ABTA> <ATOL/> <LeadPassenger>Watson</LeadPassenger> <Duration>3</Duration> <Adults>2</Adults> <Children>0</Children> <Infants>0</Infants> <Seniors>0</Seniors> <BookingElements> <BookingElement> <BookingItem>1</BookingItem> <ElementRef>HBD-71443/1</ElementRef> <ElementType>Hotel</ElementType> <GrossSale>162.77</GrossSale> <Commission>30.93</Commission> <CommissionVAT>0.00</CommissionVAT> <CreditorID/> <CreditorName/> <CreditorCurrency>EUR</CreditorCurrency> <NettOriginatingCurrency>150.17</NettOriginatingCurrency> <BookingExchangeRate>1.13900</BookingExchangeRate> <NettSterling>131.84</NettSterling> <Deposit>0.00</Deposit> <LastModified>09-27-11</LastModified> <SupplyInEC>Y</SupplyInEC> <SupplierReference>53945492</SupplierReference> <Adults>2</Adults> <Children>0</Children> <Infants>0</Infants> <Seniors>0</Seniors> <Duration>3</Duration> <HotelName>Medplaya Hotel Regente</HotelName> <Resort>Benidorm</Resort> <Country>ES</Country> <BoardBasis>Half Board</BoardBasis> <StarRating>3</StarRating> </BookingElement> </BookingElements> <BookingReceipts> <Receipt> <Description>Trade Payment</Description> <Amount>256.06</Amount> <HandlingFee>0.00</HandlingFee> <MerchantFee>0.00</MerchantFee> </Receipt> </BookingReceipts> <BookingSupplements> </BookingSupplements> </Booking> </BookingList> </Root>' select * from openxml(@hdoc,N'/documents/navreport_hbd_2012-02-15')
<?xml version="1.0"?> -<BookingList> -<Booking> <BookingRef>HBD-71443</BookingRef>
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)