UFN_MKTSEGMENTATIONFINDERNUMBER_GETSEGMENTATION

Returns the segmentation for a provided finder number.

Return

Return Type
uniqueidentifier

Parameters

Parameter	Parameter Type	Mode	Description
@FINDERNUMBER	bigint	IN

Definition

Copy



create function dbo.[UFN_MKTSEGMENTATIONFINDERNUMBER_GETSEGMENTATION]
(
  @FINDERNUMBER bigint
)
returns uniqueidentifier
as
begin
  declare @CHECKDIGIT bit;
  declare @LAST_FINDERNUMBER bigint;
  declare @SEGMENTATIONID uniqueidentifier;

  select 
    @CHECKDIGIT = [CHECKDIGIT],
    @LAST_FINDERNUMBER = [LAST_FINDERNUMBER]
  from dbo.[MKTFINDERNUMBER];

  if @FINDERNUMBER > @LAST_FINDERNUMBER and @CHECKDIGIT = 1
    select @SEGMENTATIONID = [FN].[SEGMENTATIONID]
    from dbo.[MKTSEGMENTATIONFINDERNUMBER] [FN]
    where @FINDERNUMBER / 10 between [FN].[MIN] and [FN].[MAX];
  else
    select @SEGMENTATIONID = [FN].[SEGMENTATIONID]
    from dbo.[MKTSEGMENTATIONFINDERNUMBER] [FN]
    where @FINDERNUMBER between [FN].[MIN] and [FN].[MAX]; 

  return @SEGMENTATIONID;
end