mdv 9731 (1/28/2011)
I'm not really going to comment on that answer.Just happy you are not creating any kind of BI og reporting in our company 🙂
I might be wrong but i still question the result.
Even if i know that it doesnt make much practical sence to talk deviation on 1 value.
The question was about the result of the query (ergo: what does SQL Server do with it).
Not what is the theoretical result according to statistics. (however, the explanation might be lacking. I'm (luckily) not a statistician)
But don't worry, if I'll do BI or reporting in your company, I will read the requirements thoroughly 😉
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP