UFN_MKTSEGMENTATIONSEGMENTLIST_BASECURRENCYIDMATCHESPARENTBASECURRENCYID

Ensures that the base currency on a marketing effort list segment matches that of its source marketing effort.

Return

Return Type
bit

Parameters

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

Definition

Copy



create function dbo.[UFN_MKTSEGMENTATIONSEGMENTLIST_BASECURRENCYIDMATCHESPARENTBASECURRENCYID]
(
  @BASECURRENCYID uniqueidentifier,
  @EFFORTID uniqueidentifier
)
returns bit
as 
  begin
    declare @MATCH bit;
    declare @EFFORTBASECURRENCYID uniqueidentifier;

    set @MATCH = 1;

    if not @EFFORTID is null
      begin
        select @EFFORTBASECURRENCYID = [MKTSEGMENTATION].[BASECURRENCYID] 
          from dbo.[MKTSEGMENTATION] 
          where [MKTSEGMENTATION].[ID] = @EFFORTID;

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

    return @MATCH;
  end;