UFN_MKTSMARTFIELD_LOYALTY

Returns the loyalty score for a constituent based on giving counts by year.

Return

Return Type
nvarchar(50)

Parameters

Parameter	Parameter Type	Mode
@year1	int	IN
@year2	int	IN
@year3	int	IN
@year4	int	IN
@year5	int	IN
@year6	int	IN
@year7	int	IN
@year8	int	IN
@year9	int	IN
@year10	int	IN

Definition

Copy



CREATE function dbo.UFN_MKTSMARTFIELD_LOYALTY
(
  @year1 int,
  @year2 int,
  @year3 int,
  @year4 int,
  @year5 int,
  @year6 int,
  @year7 int,
  @year8 int,
  @year9 int,
  @year10 int
)
returns nvarchar(50)
as begin
  return dbo.UFN_MKTSMARTFIELD_LOYALTY_2(@year1, @year1, @year1, @year1, @year1, @year1, @year1, @year1, @year1, @year1, 0);
end;