UFN_RECONCILE_GETAPPLICATIONWITHCHILDREN_FROMITEMLISTXML
used to convert an xml string to a table
Return
| Return Type |
|---|
| table |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ITEMLISTXML | xml | IN |
Definition
Copy
create function dbo.UFN_RECONCILE_GETAPPLICATIONWITHCHILDREN_FROMITEMLISTXML(@ITEMLISTXML xml)
returns table as
return (
select
T.c.value('(REVENUESPLITID)[1]','uniqueidentifier') AS 'REVENUESPLITID',
T.c.value('(APPLIED)[1]','money') AS 'APPLIED',
T.c.value('(TYPECODE)[1]','tinyint') AS 'TYPECODE',
T.c.value('(DESIGNATIONID)[1]','uniqueidentifier') AS 'DESIGNATIONID'
FROM @ITEMLISTXML.nodes('/REVENUESTREAMS/ITEM') T(c)
)