UFN_MKTSELECTION_GETUNIQUENAME
Returns a unique name for a selection by appending a counter if necessary.
Return
| Return Type |
|---|
| nvarchar(300) |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @NAME | nvarchar(300) | IN |
Definition
Copy
CREATE function dbo.[UFN_MKTSELECTION_GETUNIQUENAME]
(
@NAME nvarchar(300)
)
returns nvarchar(300)
as
begin
declare @NEWNAME nvarchar(300);
declare @COPYCOUNT int;
set @COPYCOUNT = 1;
set @NEWNAME = left('Copy of ' + @NAME, 300);
while exists(select 1 from dbo.[IDSETREGISTER] where [NAME] = @NEWNAME)
begin
set @COPYCOUNT = @COPYCOUNT + 1;
set @NEWNAME = left('Copy (' + cast(@COPYCOUNT as nvarchar(10)) + ') of ' + @NAME, 300);
end
return @NEWNAME;
end