FUNCTION fMathGetBin

Returns the value at the center of the bin where @x falls in, given a grid of @NumBin bins in the interval @x1 to @x2.

Parameters:

@x float: value of the variable.
@x1 float: lower bound of the interval.
@x2 float: upper bound of the interval.
@NumBin int: number of bins in which the inteval is partitioned.
@HasOpenUpperBound bit: true if the bins have open upper bounds (and closed lower bounds); false if the bins have open lower bounds (and closed upper bounds).
returns BinCenter float: the center of the bin, where @x falls in.
select dbo.fMathGetBin( s.z,0.1,0.7,24,0) as BinCenter, count(*) as Counts from SpecPhoto as s where primtarget&(0x04000020)!=0 and primtarget&(64|128|256)=0 and z between 0.1 and 0.7 group by dbo.fMathGetBin(s.z,0.1,0.7,24,0) order by dbo.fMathGetBin(s.z,0.1,0.7,24,0)
see also spMathHistogramNDim

Input and output parameters

name type length inout pnum

@NumBin int 4 input 4

float 8 input 0

@x float 8 input 1

@x1 float 8 input 2

@x2 float 8 input 3

@HasOpenUpperBound bit 1 input 5

name	type	length	inout	pnum
@NumBin	int	4	input	4
	float	8	input	0
@x	float	8	input	1
@x1	float	8	input	2
@x2	float	8	input	3
@HasOpenUpperBound	bit	1	input	5