UFN_CONSTITUENTMERGEPROCESS_GETTARGETCRITERIATEXT
Returns the user-friendly description of the criteria used to select the target constituent of a merge group.
Return
| Return Type |
|---|
| nvarchar(50) |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @CRITERIAID | tinyint | IN |
Definition
Copy
create function dbo.UFN_CONSTITUENTMERGEPROCESS_GETTARGETCRITERIATEXT(@CRITERIAID tinyint)
returns nvarchar(50)
with execute as caller
as
begin
declare @cs nvarchar(3);
set @cs = @CRITERIAID
declare @TEXT nvarchar(50);
select @TEXT =
case @cs
when '0' then 'Automatic'
when '1' then 'Oldest'
when '2' then 'Last Updated'
when '3' then 'Most Gifts'
else @cs
end;
return @TEXT;
end