UFN_MKTUPDATEMAILINGCOUNTS_MAKESELECTIONNAME
Returns a suggested selection name for a remove members process.
Return
| Return Type |
|---|
| nvarchar(255) |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @SEGMENTATIONID | uniqueidentifier | IN |
Definition
Copy
CREATE function dbo.UFN_MKTUPDATEMAILINGCOUNTS_MAKESELECTIONNAME
(
@SEGMENTATIONID uniqueidentifier
)
returns nvarchar(255)
as
begin
declare @SELECTIONNAME nvarchar(255);
select @SELECTIONNAME = [NAME] + ' Exclusion ' + cast( (select count(1) + 1 from dbo.[MKTSEGMENTATIONEXCLUSION] where [SEGMENTATIONID] = @SEGMENTATIONID) as nvarchar(10))
from dbo.[MKTSEGMENTATION]
where [ID] = @SEGMENTATIONID;
return @SELECTIONNAME;
end