Click or drag to resize
sqx

SQXStandardizeTable Method

Function [table] StandardizeTable([float] Value, [Vector] MeanDev)
(Transformation)

Namespace:  sqx
Assembly:  SQX (in SQX.dll) Version: 1.0.2.6 (1.0.2.6)
Syntax
C#
Copy
public static IEnumerator StandardizeTable(
	SqlDouble Value,
	Vector MeanDev
)

Parameters

Value
Type: System.Data.SqlTypesSqlDouble
[float]
MeanDev
Type: sqxVector
[Vector]

Return Value

Type: IEnumerator
[table]
Remarks
Standardize table function.

Attributes

IsDeterministic = true, IsPrecise = true, DataAccess = DataAccessKind.None, SystemDataAccess = SystemDataAccessKind.None, TableDefinition = "Value float"
Examples
SQL
Copy
WITH sample_data AS (SELECT ID, sqx.Exponential_PPF(Value, 0.5) X FROM sqx.UTable(1000, 0))
SELECT s.*, st.Value
FROM (SELECT sqx.MEANDEV(X, 0) MD FROM sample_data) a
CROSS APPLY sample_data s
CROSS APPLY sqx.StandardizeTable(s.X, a.MD) st
See Also