UFN_DISBURSEMENTPROCESSFORMNUMBERRANGE_FROMITEMLISTXML
Returns a table representation of the xml parameter.
Return
| Return Type |
|---|
| table |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ITEMLISTXML | xml | IN |
Definition
Copy
CREATE function dbo.UFN_DISBURSEMENTPROCESSFORMNUMBERRANGE_FROMITEMLISTXML(@ITEMLISTXML xml) RETURNS TABLE AS
return
(
select
T.c.value('(ID)[1]', 'uniqueidentifier') as 'ID'
,T.c.value('(RANGESTART)[1]', 'int') as 'RANGESTART'
,T.c.value('(RANGEEND)[1]', 'int') as 'RANGEEND'
,T.c.value('(RANGECOUNT)[1]', 'int') as 'RANGECOUNT'
,T.c.value('(USERACTION)[1]', 'tinyint') as 'USERACTION'
,T.c.value('(STARTNUMBER)[1]', 'nvarchar(max)') as 'STARTNUMBER'
from @ITEMLISTXML.nodes('/RANGESGRID/ITEM') T(c)
)