UFN_REGISTRANTBATCH_GETEMAILLIST_TOITEMLISTXML
Get eNewsletter items to xml
Return
| Return Type |
|---|
| xml |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @REGISTRANTBATCHID | uniqueidentifier | IN |
Definition
Copy
CREATE FUNCTION dbo.[UFN_REGISTRANTBATCH_GETEMAILLIST_TOITEMLISTXML](
@REGISTRANTBATCHID uniqueidentifier
)
returns xml
as
BEGIN
RETURN (
SELECT [EMAILLISTGUID], [ID]
FROM dbo.[UFN_REGISTRANTBATCH_GETEMAILLIST](@REGISTRANTBATCHID)
for xml raw('ITEM'),type,elements,root('SUBSCRIBEDNEWSLETTERIDS'),BINARY BASE64
)
END