UFN_MKTSPONSORSHIPMAILINGTEMPLATE_GETUNIQUENAME
Returns a unique name for a sponsorship effort template by appending a counter if necessary.
Return
| Return Type |
|---|
| nvarchar(50) |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @NAME | nvarchar(50) | IN |
Definition
Copy
CREATE function dbo.[UFN_MKTSPONSORSHIPMAILINGTEMPLATE_GETUNIQUENAME]
(
@NAME nvarchar(50)
)
returns nvarchar(50)
as
begin
declare @NEWNAME nvarchar(255);
declare @COPYCOUNT int;
set @COPYCOUNT = 0;
set @NEWNAME = left('Copy of ' + @NAME, 50);
while (select count(1) from dbo.[MKTSPONSORSHIPMAILINGTEMPLATE] where [NAME] = @NEWNAME) > 0
begin
set @COPYCOUNT = @COPYCOUNT + 1;
set @NEWNAME = left('Copy (' + cast(@COPYCOUNT as nvarchar(10)) + ') of ' + @NAME, 50);
end
return @NEWNAME;
end