USP_DATALIST_DUPLICATE_SEARCH

Returns duplicate registrants.

Parameters

Parameter	Parameter Type	Mode	Description
@LASTNAME	nvarchar(100)	IN	Last name
@FIRSTNAME	nvarchar(50)	IN	First name
@ADDRESS_POSTCODE	nvarchar(12)	IN	ZIP
@ADDRESS_ADDRESSBLOCK	nvarchar(150)	IN	Address

Definition

Copy



                CREATE procedure dbo.USP_DATALIST_DUPLICATE_SEARCH (
                    @LASTNAME nvarchar(100) = '',
                    @FIRSTNAME nvarchar(50) = '',
                    @ADDRESS_POSTCODE nvarchar(12) = '',
                    @ADDRESS_ADDRESSBLOCK nvarchar(150) = ''
                ) as begin

                    select DISTINCT                        
                        C.ID,
                        DC.MATCHPERCENTAGE,
                        C.NAME,
                        A.ADDRESSBLOCK,
                        A.CITY,
                        S.DESCRIPTION,
                        A.POSTCODE,
                        C.LOOKUPID
                    from
                        dbo.UFN_CONSTITUENT_GETDUPLICATECANDIDATES (
                            @LASTNAME,
                            @FIRSTNAME,
                            @ADDRESS_POSTCODE,
                            @ADDRESS_ADDRESSBLOCK
                        ) DC
                    left outer join
                        dbo.CONSTITUENT C on C.ID = DC.CONSTITUENTID
                    left outer join
                        dbo.ADDRESS A on A.ID = DC.ADDRESSID
                    left outer join
                        dbo.STATE S on S.ID = A.STATEID
                    order by
                        DC.MATCHPERCENTAGE desc

                end