USP_DATALIST_DUPLICATEORGANIZATION_SEARCH

Returns duplicate organizations.

Parameters

Parameter	Parameter Type	Mode	Description
@COMPANYNAME	nvarchar(100)	IN	Last name
@ADDRESS_POSTCODE	nvarchar(12)	IN	ZIP
@ADDRESS_ADDRESSBLOCK	nvarchar(150)	IN	Address
@MAXROWS	int	IN	Input parameter indicating the maximum number of rows to return.

Definition

Copy



                CREATE procedure dbo.USP_DATALIST_DUPLICATEORGANIZATION_SEARCH (
                    @COMPANYNAME nvarchar(100) = '',
                    @ADDRESS_POSTCODE nvarchar(12) = '',
                    @ADDRESS_ADDRESSBLOCK nvarchar(150) = '',
                    @MAXROWS integer = 100  
                ) as begin

                    select top(@MAXROWS)                        
                        C.ID,
                        DC.MATCHPERCENTAGE,
                        C.NAME,
                        A.ADDRESSBLOCK,
                        A.CITY,
                        S.DESCRIPTION,
                        A.POSTCODE,
                        C.LOOKUPID
                    from
                        dbo.UFN_ORGANIZATION_GETDUPLICATECANDIDATES (
                            @COMPANYNAME,
                            '',
                            @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