UFN_MKTCOMMUNICATIONTEMPLATE_APPEALEXISTS

create function dbo.[UFN_MKTCOMMUNICATIONTEMPLATE_APPEALEXISTS]
(
  @COMMUNICATIONTEMPLATEID uniqueidentifier
)
returns bit
with execute as caller
as 

begin
  declare @APPEALEXISTS bit = 0;

  if exists(select top 1 1 from dbo.[MKTCOMMUNICATIONTEMPLATEDEFAULTAPPEAL] where [COMMUNICATIONTEMPLATEID] = @COMMUNICATIONTEMPLATEID)
    set @APPEALEXISTS = 1;

  return @APPEALEXISTS;
end