UFN_MARRIAGERELATIONSHIP_ISUNIQUE

create function dbo.UFN_MARRIAGERELATIONSHIP_ISUNIQUE
(
  @SPOUSEGENDERCODE tinyint,
  @SPOUSERELATIONSHIPTYPECODEID uniqueidentifier
)
returns bit
with execute as caller
as begin
  declare @DUPLICATECOUNT int;

  select
    @DUPLICATECOUNT = count(*)
  from
    dbo.MARRIAGERELATIONSHIP
  where
    (@SPOUSEGENDERCODE = 3 or 
    SPOUSEGENDERCODE = 3 or
    SPOUSEGENDERCODE = @SPOUSEGENDERCODE) and 
    SPOUSERELATIONSHIPTYPECODEID = @SPOUSERELATIONSHIPTYPECODEID;

  if (@DUPLICATECOUNT <= 1)
    return 1;

  return 0;
end