UFN_UNMAPPEDTRANSACTIONERROR_GETSELECTEDERRORS_FROMITEMLISTXML
Return a table of the errors
Return
| Return Type |
|---|
| table |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ITEMLISTXML | xml | IN |
Definition
Copy
CREATE function dbo.UFN_UNMAPPEDTRANSACTIONERROR_GETSELECTEDERRORS_FROMITEMLISTXML
(
@ITEMLISTXML xml
)
returns table as
return (
select
T.c.value('(ID)[1]','uniqueidentifier') AS 'ID',
T.c.value('(ERRORMESSAGE)[1]','nvarchar(max)') as 'ERRORMESSAGE',
T.c.value('(INCLUDE)[1]','bit') as 'INCLUDE'
from @ITEMLISTXML.nodes('/MESSAGES/ITEM') T(c)
)