Tolerance/Rounding issues in Comparing Decimal Values
Is this a way to allow a tolerance on the comparison of decimal values with SQL Data Compare 8?
For example, for a particular comparison key in my table/view, I have a comparison column which is defined in both DBs as decimal(28, 8 ). In one DB this columns value is 7343.50000000000 and in the other it is 7343.4999999999 - this obviously shows up as a difference in the comparison. Is there a way to set a tollerance (say +/- 1% or +/- 0.1) so that these rows are considered the same please?