SQL Server Management Studio - Stat function

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

SQL Server Management Studio - Stat function

Author

Topic

OWSQL
Starting Member

27 Posts

Posted - 2011-07-27 : 09:28:02

Hi
Does anyone know if SQL Server Management Studio has any statistical functions included? In particular I am looking for the standard normal cumulative distribution function.

Thanks in advance!

Seventhnight
Master Smack Fu Yak Hacker

2878 Posts

Posted - 2011-07-27 : 09:44:07

Aggregate Functions:
http://msdn.microsoft.com/en-us/library/ms173454.aspx

Math Functions:
http://msdn.microsoft.com/en-us/library/ms177516.aspx

Corey

I Has Returned!!

robvolk
Most Valuable Yak

15732 Posts

Posted - 2011-07-27 : 09:45:19

These are the only built-in aggregate functions: http://msdn.microsoft.com/en-us/library/ms173454.aspx

Based on the Wikipedia definition: http://en.wikipedia.org/wiki/Normal_distribution

You may be able to calculate it from those functions. Otherwise you'll have to create a CLR aggregate function, or download and install an existing CLR function library.

It's possible Peter (SwePeso) has that function in his library: http://www.developerworkshop.net/software.html

Taken from this thread: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=77311

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources