UFN_CONSTITUENTDUPLICATESEARCH_DEFAULTADDRESS
Return
| Return Type |
|---|
| nvarchar(250) |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @CONSTITUENTID | uniqueidentifier | IN | |
| @ADDRESSTYPECODEID | uniqueidentifier | IN |
Definition
Copy
create function dbo.UFN_CONSTITUENTDUPLICATESEARCH_DEFAULTADDRESS
(
@CONSTITUENTID uniqueidentifier,
@ADDRESSTYPECODEID uniqueidentifier
)
returns nvarchar(250)
as
begin
declare @FULLADDRESS nvarchar(250)
select top 1 @FULLADDRESS = dbo.UFN_BUILDFULLADDRESS(ID,ADDRESSBLOCK,CITY,STATEID,POSTCODE,COUNTRYID)
from dbo.ADDRESS where CONSTITUENTID = @CONSTITUENTID
order by case when @ADDRESSTYPECODEID is not null and ADDRESSTYPECODEID = @ADDRESSTYPECODEID then 1 else 2 end, ISPRIMARY desc
return coalesce(@FULLADDRESS,'No address')
end