UFN_MKTASKLADDER_NEXTMINIMUMENTRYAMOUNT

CREATE function dbo.[UFN_MKTASKLADDER_NEXTMINIMUMENTRYAMOUNT]
(
  @ASKLADDERID uniqueidentifier,
  @MINIMUMENTRYAMOUNT decimal(20, 4)
)
returns decimal(20, 4)
as 
  begin
    declare @VALUE decimal(20, 4);

    set @VALUE = 9999999999.9999;

    select top 1 
      @VALUE = [MINIMUMENTRYAMOUNT] 
    from dbo.[MKTASKLADDERITEM] 
    where [ASKLADDERID] = @ASKLADDERID 
    and [MINIMUMENTRYAMOUNT] > @MINIMUMENTRYAMOUNT 
    order by [MINIMUMENTRYAMOUNT];

    return @VALUE
  end