Click or drag to resize
sqx

SQXMinMaxMatrix Method

Procedure MinMaxMatrix [nvarchar](max) @Query, [bit] @SnapShot, [Matrix] @MinMaxMatrix OUTPUT

Namespace:  sqx
Assembly:  SQX (in SQX.dll) Version: 1.0.2.6 (1.0.2.6)
Syntax
C#
Copy
public static int MinMaxMatrix(
	SqlChars Query,
	SqlBoolean SnapShot,
	out Matrix MinMaxMatrix
)

Parameters

Query
Type: System.Data.SqlTypesSqlChars
[nvarchar](max)
SnapShot
Type: System.Data.SqlTypesSqlBoolean
[bit] 0 Read Commited | 1 SnapShot
MinMaxMatrix
Type: sqxMatrix
[Matrix] Output

Return Value

Type: Int32
[int] 0 success | -1 failure
Remarks
High performance Min and Max Matrix procedure.

NOTE: Query must return a dataset with only the matrix columns with numeric data type.
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