UFN_MKTASKLADDER_FIXENTRYAMOUNT

Ensures that a given entry amount is valid for an ask ladder.

Return

Return Type
decimal(20, 4)

Parameters

Parameter	Parameter Type	Mode	Description
@ASKLADDERID	uniqueidentifier	IN
@ENTRYAMOUNT	decimal(20, 4)	IN

Definition

Copy



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

    if @ENTRYAMOUNT is null
      set @VALUE = 0.0000
    else
      begin
        declare @MINVALUE decimal(20, 4);

        select @MINVALUE = isnull(min([MINIMUMENTRYAMOUNT]), 0) from dbo.[MKTASKLADDERITEM] where [ASKLADDERID] = @ASKLADDERID;

        if @ENTRYAMOUNT < @MINVALUE 
          set @VALUE = null
        else
          set @VALUE = @ENTRYAMOUNT
      end

    return @VALUE
  end