UFN_MKTSEGMENT_ISINUSE

Returns true if the segment is in use by a marketing effort or acknowledgement template.

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode	Description
@SEGMENTID	uniqueidentifier	IN

Definition

Copy



CREATE function dbo.[UFN_MKTSEGMENT_ISINUSE]
(
  @SEGMENTID uniqueidentifier
)
returns bit
as begin
  declare @ret bit;

  set @ret = (case when exists(select top 1 1 from dbo.[MKTSEGMENTATIONSEGMENT] where [SEGMENTID] = @SEGMENTID)
                     or exists(select top 1 1 from dbo.[MKTACKNOWLEDGEMENTMAILINGTEMPLATERULE] where [SEGMENTID] = @SEGMENTID)
                     or exists(select top 1 1 from dbo.[MKTMEMBERSHIPMAILINGTEMPLATERULE] where [SEGMENTID] = @SEGMENTID)
                     or exists(select top 1 1 from dbo.[MKTSPONSORSHIPMAILINGTEMPLATERULE] where [SEGMENTID] = @SEGMENTID)
              then 1 else 0 end);

  return @ret;
end