Press "Enter" to skip to content

Fixing Distributional Rounding Errors in SQL Server

Daniel Hutmacher just wants those fractions of pennies:

A number of business processes require you to distribute a value over a date range. However, if your distribution keys and values don’t add up perfectly or aren’t perfectly divisible, it’s very easy to get rounding errors in your distributions.

Read on for an example of the problem and how you can fix it.