UFN_FINDCONSTITUENTMATCHES_COMPOSITETHRESHOLD

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode
@FIRSTNAME	nvarchar(50)	IN
@KEYNAME	nvarchar(100)	IN
@ADDRESSBLOCK	nvarchar(150)	IN
@POSTCODE	nvarchar(12)	IN
@COUNTRYID	uniqueidentifier	IN
@ISORGANIZATION	bit	IN
@ISGROUP	bit	IN
@OVERALLMATCHTHRESHOLD	tinyint	IN

Definition

Copy



CREATE function dbo.UFN_FINDCONSTITUENTMATCHES_COMPOSITETHRESHOLD (
  @FIRSTNAME nvarchar(50),
  @KEYNAME nvarchar(100),
  @ADDRESSBLOCK nvarchar(150),
  @POSTCODE nvarchar(12),
  @COUNTRYID uniqueidentifier,
  @ISORGANIZATION bit,
  @ISGROUP bit,
  @OVERALLMATCHTHRESHOLD tinyint = null
)
returns @MATCHES table (
  CONSTITUENTID uniqueidentifier,
  ADDRESSID uniqueidentifier,
  MATCHPERCENTAGE tinyint
)
as
begin
  insert into @MATCHES
  select CONSTITUENTID, ADDRESSID, MATCHPERCENTAGE
  from dbo.UFN_FINDCONSTITUENTMATCHES_COMPOSITETHRESHOLD_2(null, @FIRSTNAME, null, @KEYNAME, null, @ADDRESSBLOCK, @POSTCODE, @COUNTRYID, @ISORGANIZATION, @ISGROUP, null, null, null, null, @OVERALLMATCHTHRESHOLD, null);

  return
end