UFN_RESERVATION_GETATTENDEES_FROMITEMLISTXML
Returns a table containing attendees from the given xml.
Return
| Return Type |
|---|
| table |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ITEMLISTXML | xml | IN |
Definition
Copy
create function dbo.UFN_RESERVATION_GETATTENDEES_FROMITEMLISTXML(@ITEMLISTXML xml)
returns table as
return
(
select
T.itineraries.value('(ITINERARYID)[1]','uniqueidentifier') AS 'ITINERARYID',
T.itineraries.value('(PRICETYPECODEID)[1]','uniqueidentifier') as 'PRICETYPECODEID',
T.itineraries.value('(QUANTITY)[1]','integer') AS 'QUANTITY',
T.itineraries.value('(ID)[1]','uniqueidentifier') as 'ID'
from
@ITEMLISTXML.nodes('/ITINERARIES/ITEM') T(itineraries)
)