USP_AMPROIMPORT_MATCHCONSTITUENT

Returns constituents which might be a match for a person in AuctionMaestro Pro.

Parameters

Parameter	Parameter Type	Mode
@KEYNAME	nvarchar(100)	IN
@FIRSTNAME	nvarchar(50)	IN
@POSTCODE	nvarchar(12)	IN
@ADDRESSBLOCK	nvarchar(150)	IN

Definition

Copy



            create procedure dbo.USP_AMPROIMPORT_MATCHCONSTITUENT
            (
                @KEYNAME nvarchar(100) = '',
                @FIRSTNAME nvarchar(50) = '',
                @POSTCODE nvarchar(12) = '',
                @ADDRESSBLOCK nvarchar(150) = ''
            )
            as 
            set nocount on;

            select CONSTITUENTID, ADDRESSID, MATCHPERCENTAGE 
            from dbo.UFN_CONSTITUENT_GETDUPLICATECANDIDATES(@KEYNAME, @FIRSTNAME, @POSTCODE, @ADDRESSBLOCK)