Click or drag to resize
sqx

SQXMinMaxTable Method

Function [table] MinMaxTable([Matrix] MinMaxMatrix)

Namespace:  sqx
Assembly:  SQX (in SQX.dll) Version: 1.0.2.6 (1.0.2.6)
Syntax
C#
Copy
public static IEnumerator MinMaxTable(
	Matrix MinMaxMatrix
)

Parameters

MinMaxMatrix
Type: sqxMatrix
[Matrix]

Return Value

Type: IEnumerator
[table]
Remarks

Attributes

IsDeterministic = true, IsPrecise = true, DataAccess = DataAccessKind.None, SystemDataAccess = SystemDataAccessKind.None, TableDefinition = "ID int,MinValue float,MaxValue float"
Examples
SQL
Copy
declare @Query nvarchar(max) = N'
select a.Value [1],b.Value [2],c.Value [3]
from sqx.VectorTable(sqx.RandomVector(10,1)) a
inner join sqx.VectorTable(sqx.RandomVector(10,2)) b ON a.ID = b.ID
inner join sqx.VectorTable(sqx.RandomVector(10,3)) c ON a.ID = c.ID
'
declare @A sqx.Matrix
exec sqx.MinMaxMatrix @Query = @Query, @SnapShot = 0, @MinMaxMatrix = @A OUTPUT
exec sqx.MatrixToTable @A
select * from sqx.MinMaxTable(@A)
/*
ID          1                      2                      3
----------- ---------------------- ---------------------- -------------------
1           0.101266453555444      0.0112066529743404     0.180578214666144   Mins
2           0.943862276125635      0.985047052607428      0.947231081755474   Maxs

ID          MinValue               MaxValue
----------- ---------------------- ----------------------
1           0.101266453555444      0.943862276125635
2           0.0112066529743404     0.985047052607428
3           0.180578214666144      0.947231081755474*/
See Also