sharath.chalamgari (1/28/2011)

---

Koen (da-zero) (1/28/2011)

Then why is the explanation confusing? I find it pretty clear...

It is Confusing because in his Query the parameter 1 does not mean that Number of samples.if you put 100 inplace of 1 still it gives the same null. as per his explanation it is not a divide by zero error

The usage of the Function is wrong in the Query.

see if we can use some thing like below it gives 0

SELECT STDEV(1) from sys.objects