Post Reply 
Best HP Financial Calculator
05-06-2015, 11:07 AM
Post: #40
RE: Best HP Financial Calculator
(05-06-2015 12:53 AM)TASP Wrote:  Thanks for that. I can imagine 'bean counters' stroking out over even trifling sums if the cause of the discrepancy is unknown.

And in iterative calculations, I'm thinking even 'non-obscene' amounts of money might start building up round off errors, and if 2 differing machines yielded differing errors, I can imagine some of the accounting staff running into the night, screaming and pulling their hair out.

Definitely. Fortunately, SQL Server supports up to 38 digits for the fixed-point decimal data type, with a selectable decimal point position. Using 38 digits costs 17 bytes per value, though. Most of our databases use 19 digits with 5 after the decimal point, 19 being the most you can get for 9 bytes.
Visit this user's website Find all posts by this user
Quote this message in a reply
Post Reply 


Messages In This Thread
RE: Best HP Financial Calculator - John R - 03-18-2015, 03:20 AM
RE: Best HP Financial Calculator - Jlouis - 03-18-2015, 10:23 AM
RE: Best HP Financial Calculator - RayLuca - 05-14-2015, 10:52 AM
RE: Best HP Financial Calculator - RayLuca - 05-14-2015, 12:16 PM
RE: Best HP Financial Calculator - TASP - 03-21-2015, 06:40 PM
RE: Best HP Financial Calculator - Gene - 05-05-2015, 09:54 PM
RE: Best HP Financial Calculator - TASP - 05-05-2015, 11:22 PM
RE: Best HP Financial Calculator - TASP - 05-06-2015, 12:53 AM
RE: Best HP Financial Calculator - Dave Britten - 05-06-2015 11:07 AM
RE: Best HP Financial Calculator - TASP - 05-09-2015, 01:05 PM
RE: Best HP Financial Calculator - emece67 - 05-14-2015, 04:52 PM



User(s) browsing this thread: 1 Guest(s)