UFN_MKTSOURCECODEPARTDEFINITIONVALUE_GETAUTOINCREMENTSETTING

create function dbo.[UFN_MKTSOURCECODEPARTDEFINITIONVALUE_GETAUTOINCREMENTSETTING]
(
  @PARTDEFINITIONVALUESID uniqueidentifier
)
returns bit
as
  begin
    declare @AUTOINCREMENTCODE bit;

    if @PARTDEFINITIONVALUESID is not null
      select 
        @AUTOINCREMENTCODE = [AUTOINCREMENTVALUE]
      from dbo.[MKTSOURCECODEPARTDEFINITION]
      inner join dbo.[MKTSOURCECODEPARTDEFINITIONVALUES] on [MKTSOURCECODEPARTDEFINITIONVALUES].[MKTSOURCECODEPARTDEFINITIONID] = [MKTSOURCECODEPARTDEFINITION].[ID]
      where [MKTSOURCECODEPARTDEFINITIONVALUES].[ID] = @PARTDEFINITIONVALUESID;
    else
      set @AUTOINCREMENTCODE = 0;

    return @AUTOINCREMENTCODE;
  end