Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Timmed Mean
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Titre:
Divers
Thread ID:
00764927
Message ID:
00766770
Vues:
21
>I get the exact same value... maybe I was just being paranoid. Your method does make more sense to me though. I think Ill use it instead of mine. Thanks for your input.

Eric,

You would get the same result on a small result set. For example,
Your query 100*.95*.95  && 90.25 rounded to 90
My query 90
The bigger result gets the bigger will be difference between results returned.
Your query 1000*.95*.95  && 902.5 rounded to 903
My query 900 
Difference 3 records
--sb--
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform