UFN_MKTSEGMENTATIONEXPORTPROCESS_GETPACKAGELISTFROMXML
Returns a comma-delimited list of the packages from a /PACKAGE/ITEM/ID xml.
Return
| Return Type |
|---|
| nvarchar(max) |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @XML | xml | IN |
Definition
Copy
create function dbo.UFN_MKTSEGMENTATIONEXPORTPROCESS_GETPACKAGELISTFROMXML
(
@XML xml
)
returns nvarchar(max)
as
begin
declare @PACKAGES nvarchar(max);
select @PACKAGES = coalesce(@PACKAGES + ', ','') + [MKTPACKAGE].[NAME]
from [MKTPACKAGE]
inner join (
select T.c.value('(ID)[1]','uniqueidentifier') [PACKAGEID]
from @XML.nodes('/PACKAGES/ITEM') T(c)
) [IDS] on [IDS].[PACKAGEID] = [MKTPACKAGE].[ID]
return @PACKAGES
end