UFN_MKTASKLADDER_GETWRITEINTEXT

Returns the ask ladder write-in text based on an entry amount and an ask ladder ID.

Return

Return Type
nvarchar(100)

Parameters

Parameter	Parameter Type	Mode	Description
@ASKLADDERID	uniqueidentifier	IN
@ENTRYAMOUNT	money	IN

Definition

Copy



CREATE function dbo.[UFN_MKTASKLADDER_GETWRITEINTEXT]
(
  @ASKLADDERID uniqueidentifier,
  @ENTRYAMOUNT money
)
returns nvarchar(100)
as 
  begin
    declare @WRITEINTEXT nvarchar(100);

    select 
      @WRITEINTEXT = [WRITEINTEXT] 
    from dbo.[MKTASKLADDER] as [L]
    left join dbo.[MKTASKLADDERITEM] as [I] on ([L].[ID] = [I].[ASKLADDERID] and @ENTRYAMOUNT between [MINIMUMENTRYAMOUNT] and ([NEXTMINIMUMENTRYAMOUNT] - .0001))
    where [L].[ID] = @ASKLADDERID;

    if @WRITEINTEXT is null
      set @WRITEINTEXT = '';

    return @WRITEINTEXT
  end