USP_DATALIST_AMPROAUTOMATCH

Returns potential matches for a constituent imported from AuctionMaestro Pro.

Parameters

Parameter	Parameter Type	Mode	Description
@KEYNAME	nvarchar(100)	IN	Key name
@FIRSTNAME	nvarchar(50)	IN	First name
@POSTCODE	nvarchar(12)	IN	Post code
@ADDRESSBLOCK	nvarchar(150)	IN	Address block

Definition

Copy



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

                select 
                    [T].CONSTITUENTID, 
                    [T].MATCHPERCENTAGE,
                    CONSTITUENT.NAME,
                    ADDRESS.ADDRESSBLOCK,
                    ADDRESS.CITY,
                    (select top 1 DESCRIPTION from dbo.STATE where STATE.ID = ADDRESS.STATEID) as [STATE],
                    ADDRESS.POSTCODE,
                    CONSTITUENT.LOOKUPID
                from dbo.UFN_CONSTITUENT_GETDUPLICATECANDIDATES(@KEYNAME, @FIRSTNAME, @POSTCODE, @ADDRESSBLOCK) as [T]
                left join dbo.CONSTITUENT on CONSTITUENT.ID = [T].CONSTITUENTID
                left join dbo.ADDRESS on ADDRESS.ID = [T].ADDRESSID
                order by [T].MATCHPERCENTAGE desc, CONSTITUENT.NAME asc, ADDRESS.CITY asc, ADDRESS.ADDRESSBLOCK asc