Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Std Deviation and UDFs in SQL Select
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00233026
Message ID:
00234726
Vues:
39
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform