I've found a query entity in our system that seems to round large decimals and remove everything after the decimal if the overall character length is eight or greater.
Example:
If the value is 12345678.90 the query returns 12345679.
The DB structure has the field set to decimal(14,2), the CDT is set to a double with the annotation being decimal(14,2), and if the character length is less than eight then it returns the correct value.
How can I get the DB to return the correct value?
Thanks!
Discussion posts and replies are publicly visible