select 1354.44*.528 = 715.14432 Select round(715.14432,2) / .528 = 1354.431818181 We are facing one round of issue error in our production server sql server 2008R2 While round off the first select resulted amount ,It would match the exact amount
1354.44.It will differ 0.01 differences.
Can you not just do `select round((1354.44*.528) / 0.528, 2)`? Rounding only needs to be done on the answer. If you round values you do calculations on you loose accuracy. This gives `1354.440000000` which I think is the answer you are looking for?