UFN_MKTSEGMENTATIONTESTSEGMENT_BASECURRENCYIDMATCHESPARENTBASECURRENCYID

Ensures that the base currency on a marketing effort test segment matches that of its parent segment.

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode	Description
@BASECURRENCYID	uniqueidentifier	IN
@SEGMENTID	uniqueidentifier	IN

Definition

Copy



create function dbo.[UFN_MKTSEGMENTATIONTESTSEGMENT_BASECURRENCYIDMATCHESPARENTBASECURRENCYID]
(
  @BASECURRENCYID uniqueidentifier,
  @SEGMENTID uniqueidentifier
)
returns bit
as 
  begin
    declare @MATCH bit;
    declare @SEGMENTBASECURRENCYID uniqueidentifier;

    set @MATCH = 1;

    if not @SEGMENTID is null
      begin
        select @SEGMENTBASECURRENCYID = [MKTSEGMENTATIONSEGMENT].[BASECURRENCYID] 
          from dbo.[MKTSEGMENTATIONSEGMENT] 
          where [MKTSEGMENTATIONSEGMENT].[ID] = @SEGMENTID;

        if @BASECURRENCYID is not null
          set @MATCH = (select case when @BASECURRENCYID = @SEGMENTBASECURRENCYID then 1 else 0 end);
      end;

    return @MATCH;
  end;