UFN_MKTASKLADDER_ISINUSE

Returns true if the ask ladder is in use by a marketing effort segment, marketing effort ask ladder override or an appeal mailing.

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode	Description
@ASKLADDERID	uniqueidentifier	IN

Definition

Copy



CREATE function dbo.[UFN_MKTASKLADDER_ISINUSE]
(
  @ASKLADDERID uniqueidentifier
)
returns bit
as
  begin
    declare @INUSE bit;

    set @INUSE = case 
      when exists (select top 1 1 from dbo.[MKTSEGMENTATIONSEGMENT] inner join dbo.[MKTSEGMENTATION] on [MKTSEGMENTATIONSEGMENT].[SEGMENTATIONID] = [MKTSEGMENTATION].[ID] where [MKTSEGMENTATIONSEGMENT].[ASKLADDERID] = @ASKLADDERID and [MKTSEGMENTATION].[ACTIVE] <> 0)
        or exists (select top 1 1 from dbo.[MKTSEGMENTATIONTESTSEGMENT]
                   inner join dbo.[MKTSEGMENTATIONSEGMENT] on [MKTSEGMENTATIONTESTSEGMENT].[SEGMENTID] = [MKTSEGMENTATIONSEGMENT].[ID]
                   inner join dbo.[MKTSEGMENTATION] on [MKTSEGMENTATIONSEGMENT].[SEGMENTATIONID] = [MKTSEGMENTATION].[ID] where [MKTSEGMENTATIONTESTSEGMENT].[ASKLADDERID] = @ASKLADDERID and [MKTSEGMENTATION].[ACTIVE] <> 0)
        or exists (select top 1 1 from dbo.[MKTSEGMENTATIONASKLADDEROVERRIDE] inner join dbo.[MKTSEGMENTATION] on [MKTSEGMENTATIONASKLADDEROVERRIDE].[SEGMENTATIONID] = [MKTSEGMENTATION].[ID] where [MKTSEGMENTATIONASKLADDEROVERRIDE].[ASKLADDERID] = @ASKLADDERID and [MKTSEGMENTATION].[ACTIVE] <> 0)
        or exists (select top 1 1 from dbo.[APPEALMAILINGSETUP] where [MKTASKLADDERID] = @ASKLADDERID)
        or exists (select top 1 1 from dbo.[MKTCOMMUNICATIONTEMPLATEDEFAULTASKLADDEROVERRIDE] where [ASKLADDERID] = @ASKLADDERID)
      then 1 else 0 end;

    return @INUSE
  end