UFN_SELECTIVECOMMUNICATIONLETTERS_GETLETTEROPTIONS_FROMITEMLISTXML
Return
| Return Type |
|---|
| table |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @LETTEROPTIONS | xml | IN |
Definition
Copy
CREATE function dbo.UFN_SELECTIVECOMMUNICATIONLETTERS_GETLETTEROPTIONS_FROMITEMLISTXML
(
@LETTEROPTIONS xml
)
returns table
as return (
select
T.c.value('(ID)[1]','uniqueidentifier') as ID,
T.c.value('(RUNNOW)[1]','bit') as RUNNOW
from @LETTEROPTIONS.nodes('/LETTEROPTIONS/ITEM') T(c)
)