UFN_MKTEXPORTDEFINITION_GETUNIQUEDATALISTNAME
Returns a unique name for an export definition's preview data list by appending a counter if necessary.
Return
| Return Type |
|---|
| nvarchar(60) |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @NAME | nvarchar(60) | IN | |
| @ID | uniqueidentifier | IN |
Definition
Copy
CREATE function dbo.[UFN_MKTEXPORTDEFINITION_GETUNIQUEDATALISTNAME]
(
@NAME nvarchar(60),
@ID uniqueidentifier
)
returns nvarchar(60)
as
begin
declare @UNIQUENAME nvarchar(60);
declare @COUNT int;
declare @SUFFIX nvarchar(10);
set @COUNT = 1;
set @UNIQUENAME = @NAME;
while exists(select top 1 1 from dbo.[DATALISTCATALOG] where [NAME] = @UNIQUENAME and [ID] <> @ID)
begin
set @COUNT = @COUNT + 1;
set @SUFFIX = ' ' + convert(nvarchar, @COUNT);
if len(@NAME + @SUFFIX) > 60
set @NAME = left(@NAME, len(@NAME) - len(@SUFFIX));
set @UNIQUENAME = @NAME + @SUFFIX;
end
return @UNIQUENAME;
end