UFN_CONSTITUENT_HAVECONFLICTINGCONSENTSOLICITCODES

CREATE function dbo.UFN_CONSTITUENT_HAVECONFLICTINGCONSENTSOLICITCODES
(
  @SOURCEID uniqueidentifier,
  @TARGETID uniqueidentifier
)
returns bit
with execute as caller
as begin
  declare @RETURN bit = 0;

  select
    @RETURN = case
      when count(1) > 0 then convert(bit, 1)
      else convert(bit, 0)
    end
  from dbo.SOLICITCODE
    inner join dbo.CONSTITUENTSOLICITCODE SOURCECODE on SOLICITCODE.ID = SOURCECODE.SOLICITCODEID
    inner join dbo.CONSTITUENTSOLICITCODE TARGETCODE on SOLICITCODE.ID = TARGETCODE.SOLICITCODEID
  where
    (SOLICITCODE.CONSENTCODE = 1 or SOLICITCODE.CONSENTCODE = 2)
    and SOURCECODE.CONSTITUENTID = @SOURCEID
    and TARGETCODE.CONSTITUENTID = @TARGETID
    and dbo.UFN_DATES_AREDATESOVERLAPPING(SOURCECODE.STARTDATE, SOURCECODE.ENDDATE, TARGETCODE.STARTDATE, TARGETCODE.ENDDATE) = 1;

  return @RETURN;
end