SQL Data Types
Both FLOAT and REAL are approximate number data types. FLOAT storage size is 8 bytes. REAL storage size is 4 bytes.
I used REAL as a return type in a stored procedure. The difference in precision cause the two reports not to match.
I should not have used either of these approximate number data types. I think DECIMAL(18,2) would have been a better choice.