UFN_RELATIONSHIP_ADDRESS_VALID
Checks addresses/relationships on constituent merge
Return
| Return Type |
|---|
| bit |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @CONSTITUENTID | uniqueidentifier | IN | |
| @RELATIONSHIPID | uniqueidentifier | IN |
Definition
Copy
create function dbo.UFN_RELATIONSHIP_ADDRESS_VALID (
@CONSTITUENTID uniqueidentifier,
@RELATIONSHIPID uniqueidentifier
)
returns bit
as begin
if exists(
select top 1 ID
from dbo.RELATIONSHIP
where ID = @RELATIONSHIPID and
RECIPROCALCONSTITUENTID = @CONSTITUENTID
)
return 1;
return 0;
end