UFN_MKTASKLADDER_VALUETABLE

Returns a table containing the ask amounts based on an ask ladder ID and an entry amount.

Return

Return Type
table

Parameters

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

Definition

Copy


CREATE function dbo.[UFN_MKTASKLADDER_VALUETABLE]
(
  @ASKLADDERID uniqueidentifier,
  @ENTRYAMOUNT money
)
returns table
as
  return
    (
      select 
        [L].[ID],
        dbo.[UFN_MKTASKLADDER_CALCVALUE]([I].[TYPECODE], @ENTRYAMOUNT,[I].[ITEMVALUE1], [I].[ROUNDTOAMOUNT], [I].[MINIMUMENTRYAMOUNT]) as [ASK1],
        dbo.[UFN_MKTASKLADDER_CALCVALUE]([I].[TYPECODE], @ENTRYAMOUNT,[I].[ITEMVALUE2], [I].[ROUNDTOAMOUNT], [I].[MINIMUMENTRYAMOUNT]) as [ASK2],
        dbo.[UFN_MKTASKLADDER_CALCVALUE]([I].[TYPECODE], @ENTRYAMOUNT,[I].[ITEMVALUE3], [I].[ROUNDTOAMOUNT], [I].[MINIMUMENTRYAMOUNT]) as [ASK3],
        dbo.[UFN_MKTASKLADDER_CALCVALUE]([I].[TYPECODE], @ENTRYAMOUNT,[I].[ITEMVALUE4], [I].[ROUNDTOAMOUNT], [I].[MINIMUMENTRYAMOUNT]) as [ASK4],
        dbo.[UFN_MKTASKLADDER_CALCVALUE]([I].[TYPECODE], @ENTRYAMOUNT,[I].[ITEMVALUE5], [I].[ROUNDTOAMOUNT], [I].[MINIMUMENTRYAMOUNT]) as [ASK5]
      from dbo.[MKTASKLADDER] as [L]
      left join dbo.[MKTASKLADDERITEM] as [I] on ([L].[ID] = [I].[ASKLADDERID] and dbo.[UFN_MKTASKLADDER_FIXENTRYAMOUNT]([ASKLADDERID], @ENTRYAMOUNT) between [MINIMUMENTRYAMOUNT] and ([NEXTMINIMUMENTRYAMOUNT] - .0001))
      where [L].[ID] = @ASKLADDERID
    )