UFN_MKTFINDERNUMBER_GETFIXEDWIDTH

CREATE function dbo.[UFN_MKTFINDERNUMBER_GETFIXEDWIDTH]
(
  @INCLUDECHECKDIGIT bit,
  @SEGMENTATIONID uniqueidentifier
)
returns tinyint
as
begin
  declare @MAX bigint = 0;
  declare @FIXEDWIDTH tinyint;

  if @INCLUDECHECKDIGIT = 1
    begin
      select
        @MAX = max([MAX])
      from dbo.[MKTSEGMENTATIONFINDERNUMBER]
      where [SEGMENTATIONID] = @SEGMENTATIONID;

      select top 1
        @FIXEDWIDTH = (case
                         when @MAX = 0 then
                           [FIXEDWIDTH] + [CHECKDIGIT]
                         when [LAST_FINDERNUMBER] > @MAX then
                           [FIXEDWIDTH]
                         else
                           [FIXEDWIDTH] + [CHECKDIGIT]
                       end)
      from dbo.[MKTFINDERNUMBER]
    end
  else
    begin
      select top 1
        @FIXEDWIDTH = [FIXEDWIDTH]
      from dbo.[MKTFINDERNUMBER];
    end

  return @FIXEDWIDTH;
end