Skip to main content

Posts

Showing posts from April, 2014

Losing precision after multiplication in SQL Server

CodeProject Yesterday I was doing a little multiplication operation in SQL SERVER. The computation involves multiplication of two decimal numbers. A point to note here is that I've to be very careful while performing the calculations because it's a monetary thing. So, Whatever the calculation made, it must be very accurate such that I shouldn't miss any fractions as it costs in MILLIONS. The scenario is that I've two numbers, after multiplying each other I'm losing the precision of the values . I've tried to check my database for any faulty data that caused the issue. But the data is absolutely fine .