UFN_MARRIAGEADDITIONALRELATIONSHIP_ISUNIQUE

Validates whether the marriage relationship is unique.

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode	Description
@MARRIAGEADDITIONALRELATIONSHIPID	uniqueidentifier	IN
@RELATIONSHIPTYPECODEID	uniqueidentifier	IN

Definition

Copy



create function dbo.UFN_MARRIAGEADDITIONALRELATIONSHIP_ISUNIQUE
(
  @MARRIAGEADDITIONALRELATIONSHIPID uniqueidentifier,
  @RELATIONSHIPTYPECODEID uniqueidentifier
)
returns bit
with execute as caller
as begin
  declare @DUPLICATECOUNT int = 0;

  declare @SPOUSERELATIONSHIPTYPECODEID uniqueidentifier;
  select @SPOUSERELATIONSHIPTYPECODEID = SPOUSERELATIONSHIPTYPECODEID from dbo.MARRIAGEADDITIONALRELATIONSHIP where ID = @MARRIAGEADDITIONALRELATIONSHIPID;

  select
    @DUPLICATECOUNT = count(*)
  from
    dbo.MARRIAGEADDITIONALRELATIONSHIP
  inner join dbo.MARRIAGEADDITIONALRELATIONSHIPASSOCIATION
    on MARRIAGEADDITIONALRELATIONSHIPASSOCIATION.MARRIAGEADDITIONALRELATIONSHIPID = MARRIAGEADDITIONALRELATIONSHIP.ID
  where
    MARRIAGEADDITIONALRELATIONSHIPASSOCIATION.RELATIONSHIPTYPECODEID = @RELATIONSHIPTYPECODEID and
    MARRIAGEADDITIONALRELATIONSHIP.SPOUSERELATIONSHIPTYPECODEID = @SPOUSERELATIONSHIPTYPECODEID and
    MARRIAGEADDITIONALRELATIONSHIP.ID <> @MARRIAGEADDITIONALRELATIONSHIPID;

  if (@DUPLICATECOUNT = 0)
    return 1;

  return 0;
end