UFN_FINDADDRESSMATCH
Return
| Return Type |
|---|
| table |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @CONSTITUENTID | uniqueidentifier | IN | |
| @ADDRESSBLOCK | nvarchar(150) | IN | |
| @POSTCODE | nvarchar(12) | IN | |
| @COUNTRYID | uniqueidentifier | IN | |
| @CITY | nvarchar(50) | IN | |
| @STATEID | uniqueidentifier | IN | |
| @ADDRESSTYPECODEID | uniqueidentifier | IN | |
| @ADDRESSMATCHTHRESHOLD | tinyint | IN |
Definition
Copy
CREATE function dbo.UFN_FINDADDRESSMATCH (
@CONSTITUENTID uniqueidentifier,
@ADDRESSBLOCK nvarchar(150),
@POSTCODE nvarchar(12),
@COUNTRYID uniqueidentifier,
@CITY nvarchar(50),
@STATEID uniqueidentifier,
@ADDRESSTYPECODEID uniqueidentifier,
@ADDRESSMATCHTHRESHOLD tinyint
)
returns @MATCH table(
ADDRESSID uniqueidentifier,
NOCONFLICTS bit
)
with execute as caller
as
begin
insert into @MATCH select ADDRESSID, NOCONFLICTS from dbo.UFN_FINDADDRESSMATCH_CONSTITUENTUPDATEBATCH(@CONSTITUENTID, @ADDRESSBLOCK, @POSTCODE, @COUNTRYID, @CITY, @STATEID, @ADDRESSTYPECODEID, @ADDRESSMATCHTHRESHOLD, null)
return;
end