UFN_MKTSEGMENTLIST_MAKEVIEWNAME_FORIDSET
Returns the name of the standard or duplicate view that looks at the imported list data table for a given list segment.
Return
| Return Type |
|---|
| nvarchar(63) |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @SEGMENTLISTID | uniqueidentifier | IN | |
| @ISDUPLICATE | bit | IN |
Definition
Copy
create function dbo.[UFN_MKTSEGMENTLIST_MAKEVIEWNAME_FORIDSET]
(
@SEGMENTLISTID uniqueidentifier,
@ISDUPLICATE bit
)
returns nvarchar(63)
as
begin
return 'V_MKTSEGMENTLIST_' + replace(cast(@SEGMENTLISTID as nvarchar(36)), '-', '_') + (case when @ISDUPLICATE = 1 then '_DUPLICATE' else '' end);
end