UFN_MKTSOURCECODE_INUSE

CREATE function dbo.[UFN_MKTSOURCECODE_INUSE]
(
  @SOURCECODEID uniqueidentifier
)
/*
  Returns true if source code is in use
*/
returns bit
as begin
  declare @INUSE bit;

  set @INUSE = 0;

  if exists (select top 1 1 from dbo.[MKTMARKETINGPLANITEM] where [MKTMARKETINGPLANITEM].[SOURCECODEID] = @SOURCECODEID) or
     exists (select top 1 1 from dbo.[MKTSEGMENTATION] where [MKTSEGMENTATION].[SOURCECODEID] = @SOURCECODEID) or
     exists (select top 1 1 from dbo.[MKTACKNOWLEDGEMENTMAILINGTEMPLATE] where [MKTACKNOWLEDGEMENTMAILINGTEMPLATE].[SOURCECODEID] = @SOURCECODEID) or
     exists (select top 1 1 from dbo.[MKTMEMBERSHIPMAILINGTEMPLATE] where [MKTMEMBERSHIPMAILINGTEMPLATE].[SOURCECODEID] = @SOURCECODEID) or
     exists (select top 1 1 from dbo.[MKTSPONSORSHIPMAILINGTEMPLATE] where [MKTSPONSORSHIPMAILINGTEMPLATE].[SOURCECODEID] = @SOURCECODEID) or
     exists (select top 1 1 from dbo.[MKTSEGMENTWHITEMAIL] where [MKTSEGMENTWHITEMAIL].[SOURCECODEID] = @SOURCECODEID) or
     exists (select top 1 1 from dbo.[MKTCOMMUNICATIONTEMPLATEDEFAULT] where [MKTCOMMUNICATIONTEMPLATEDEFAULT].[SOURCECODEID] = @SOURCECODEID)
    set @INUSE = 1;

  return @INUSE;
end