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