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
)