 | sqx Namespace |
SQX Structured Query Matrix for SQL Server
Classes do not exists in SQL Server, they are just a way to classify functions and procedures.
Structures are aggregate functions or data types.
NOTE: Aggregate Functions can be used in GROUP BY, HAVING and PIVOT clause.
Abstract
SQX provides scalar functions, table functions, aggregate function, store procedures and data types all under sqx schema.Classes do not exists in SQL Server, they are just a way to classify functions and procedures.
Structures are aggregate functions or data types.
NOTE: Aggregate Functions can be used in GROUP BY, HAVING and PIVOT clause.
Classes| Class | Description | |
|---|---|---|
 | ConfusionMatrix |
Confusion Matrix functions
|
| Hyperbolic |
Hyperbolic functions
|
| Probability |
Probability functions
|
| RegularExpressions |
Regular Expressions functions
|
| SQX |
Structured Query Matrix for SQL Server
|
| Trigonometric |
Trigonometric functions
|
Structures| Structure | Description | |
|---|---|---|
  | ALLVALUES |
Aggregate [bit] ALLVALUES([sql_variant] Value) |
| BINS |
Aggregate [int] BINS([float] Value) |
| ContingencyData |
Contingency Data Type
|
| COUNTIF |
Aggregate [bigint] COUNTIF([bit] Truth) |
| CROSSTAB |
Aggregate [ContingencyData] CROSSTAB([bit] Observed, [bit] Predicted) |
| CV |
Aggregate [float] CV([float] Value, [bit] Population) |
| DEV |
Aggregate [float] DEV([float] Value, [bit] Population, [smallint] Method) |
| EMPIRICAL |
Aggregate [EmpiricalData] EMPIRICAL([float] Value, [float] Target) |
| EmpiricalData |
Empirical Data Type
|
| ENTROPY |
Aggregate [float] ENTROPY([bit] Observed) |
| ENTROPYC |
Aggregate [float] ENTROPYC([bit] Observed, [float] YValue, [float] XValue) |
| ENTROPYJ |
Aggregate [float] ENTROPYJ([bit] Observed, [float] XValue, [float] YValue) |
| ENTROPYX |
Aggregate [float] ENTROPYX([bit] Observed, [float] Value) |
| FIVESUM |
Aggregate [Vector] FIVESUM([float] Value, [smallint] Method) |
| FREQUENCY |
Aggregate [bigint] FREQUENCY([float] Value, [float] Target) |
| GE |
Aggregate [float] GE([float] Value, [float] Alpha) |
| GINI |
Aggregate [float] GINI([float] Value) |
| GM |
Aggregate [float] GM([float] Value) |
| GSD |
Aggregate [float] GSD([float] Value) |
| HM |
Aggregate [float] HM([float] Value) |
| IDOFMAX |
Aggregate [int] IDOFMAX([int] ID, [float] Value, [int] Position) |
| IDOFMIN |
Aggregate [int] IDOFMIN([int] ID, [float] Value, [int] Position) |
| IG |
Aggregate [float] IG([bit] Observed, [float] Value) |
| IGR |
Aggregate [float] IGR([bit] Observed, [float] Value) |
| IQM |
Aggregate [float] IQM([float] Value, [smallint] Method) |
| IQR |
Aggregate [float] IQR([float] Value, [smallint] Method) |
| KURTOSIS |
Aggregate [float] KURTOSIS([float] Value, [bit] Population) |
| LARGE |
Aggregate [float] LARGE([float] Value, [int] OrderStatistic) |
| LM |
Aggregate [float] LM([float] value) |
| LOGADDSUM |
Aggregate [float] LOGADDSUM([float] LogValue) |
| MAE |
Aggregate [float] MAE([float] Observed, [float] Predicted) |
| MAPE |
Aggregate [float] MAPE([float] Observed, [float] Predicted) |
| Matrix |
Matrix Data Type
|
| MEAN |
Aggregate [float] MEAN([float] Value) |
| MEANDEV |
Aggregate [Vector] MEANDEV([float] Value, [bit] Population) |
| MEDIAN |
Aggregate [float] MEDIAN([float] Value) |
| MI |
Aggregate [float] MI([bit] Observed, [float] XValue, [float] YValue) |
| MINMAX |
Aggregate [Vector] MINMAX([float] Value) |
| MODE |
Aggregate [float] MODE([float] Value, [smallint] Method) |
| MOMENTS |
Aggregate [Vector] MOMENTS([float] Value, [bit] Population) |
| MSE |
Aggregate [float] MSE([float] Observed, [float] Predicted) |
| NULLS |
Aggregate [bigint] NULLS([sql_variant] Value) |
| PERCENTILE |
Aggregate [float] PERCENTILE([float] Value, [float] Percentile, [smallint] Method) |
| PRODUCT |
Aggregate [float] PRODUCT([float] Value) |
| QCD |
Aggregate [float] QCD([float] Value, [smallint] Method) |
| QUARTILE |
Aggregate [float] QUARTILE([float] Value, [smallint] Quartile, [smallint] Method) |
| RELFREQUENCY |
Aggregate [float] RELFREQUENCY([float] Value, [float] Target) |
| RMS |
Aggregate [float] sqm.RMS([float] Value) |
| ROBCOR |
Aggregate [float] ROBCOR([float] X, [float] Y, [float] MeanX, [float] MeanY, [bit] Population) |
| ROBCOV |
Aggregate [float] ROBCOV([float] X, [float] Y, [float] MeanX, [float] MeanY, [bit] Population) |
| ROBVAR |
Aggregate [float] ROBVAR([float] X, [float] MeanX, [bit] Population) |
| SKEWNESS |
Aggregate [float] SKEWNESS([float] Value, [bit] Population) |
| SMALL |
Aggregate [float] SMALL([float] Value, [int] OrderStatistic) |
| SOFTMAXSUM |
Aggregate [Vector] SOFTMAXSUM([float] Value) |
| SUMIF |
Aggregate [float] SUMIF([float] Value, [bit] Truth) |
| SUMLOGIF |
Aggregate [float] SUMLOGIF([float] Value, [bit] Truth) |
| TRIMEAN |
Aggregate [float] TRIMEAN([float] Value, [smallint] Method) |
| Vector |
Vector Data Type
|