Click or drag to resize
sqx

SQXLogBinTable Method

Function [table] LogBinTable([bigint] N, [bigint] K)
(Mathematics)

Namespace:  sqx
Assembly:  SQX (in SQX.dll) Version: 1.0.2.6 (1.0.2.6)
Syntax
C#
public static IEnumerator LogBinTable(
	SqlInt64 N,
	SqlInt64 K
)

Parameters

N
Type: System.Data.SqlTypesSqlInt64
[bigint]
K
Type: System.Data.SqlTypesSqlInt64
[bigint]

Return Value

Type: IEnumerator
[table]
Remarks
Log Binomial coefficient table Log((ⁿₖ)) function.
Support: N, K [+/-]

Attributes

IsDeterministic = true, IsPrecise = true, DataAccess = DataAccessKind.None, SystemDataAccess = SystemDataAccessKind.None, TableDefinition = "[Sign] int,[Value] float"
Examples
SQL
DECLARE @N int = -10, @K int = 3
SELECT lbt.[Sign], lbt.Value
, lbt.[Sign] * Exp(lbt.Value) BinFromLogBin
, sqx.Bin(@N,@K) Bin
FROM sqx.LogBinTable(@N,@K) lbt
/*
Sign        Value                  BinFromLogBin          Bin
----------- ---------------------- ---------------------- ------
-1          5.39362754635236       -220                   -220*/
See Also