Updated: 9 August 2010

Use BICO to calculate the binomial coefficient. This is the equivalent of the COMBIN function in the XLeratorDB/math module

SELECT [wctStatistics].[wct].[BICO] (

<@N, float,>

,<@K, float,>)

is any positive number. @*N *is an expression of type **float** or of a type that can be implicitly converted to **float**.

is any positive number. @*K *is an expression of type **float** or of a type that can be implicitly converted to **float**.

float

· If *@N *<0, BICO returns an error.

· If *@K* ≤0, BICO returns an error.

· If *@K* > *@N*, BICO returns an error.

· Both *@N* and *@K* are truncated to zero decimal places.

SELECT wct.BICO(14, 3)

This produces the following result

----------------------

364

(1 row(s) affected)