Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Std Deviation and UDFs in SQL Select
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00233026
Message ID:
00234726
Views:
38
that's true, but SQL Server and MC Access both support it.
Also, it is in the SQL standards. It doesn't matter how the Foxpro engine calculates it.

Also, I wrote a UDF to calculate STDDEV in a single pass -
(why I don't use it - it doesn't work with GROUP BY)
here's how:
It depends on PUBLIC variables to remember all average, count, sum and all the reqd. variables used to calculate STD. DEV.
It recalculates STD DEV while the SQL Statement is passing through each record.
The last value is what the SQL statement returns.
Bharat Sanghvi
Vice President, Information Technology
Deyta
Continuous Quality Measurement Systems
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform