UFN_PDACCOUNTSEGMENTMAP_FROMITEMLISTXML
UFN_PDACCOUNTSEGMENTMAP_FROMITEMLISTXML
Return
| Return Type |
|---|
| table |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ITEMLISTXML | xml | IN |
Definition
Copy
create function dbo.UFN_PDACCOUNTSEGMENTMAP_FROMITEMLISTXML(@ITEMLISTXML xml) returns table as
return (
select
T.c.value('(LONGDESCRIPTIONID)[1]','uniqueidentifier') AS 'LONGDESCRIPTIONID'
,T.c.value('(PDACCOUNTSEGMENTVALUEID)[1]','uniqueidentifier') AS 'PDACCOUNTSEGMENTVALUEID'
FROM @ITEMLISTXML.nodes('/PDACCOUNTSEGMENTMAP/ITEM') T(c)
)