Hi,
I have a query where I am subtracting two numbers, and the result is always rounded, but I need it not to do that.
The two data fields are defined in the database as numeric(17).
My query looks like this:
select tmccomcred, baamount, case when tmcomcred<>0 then baamount - tmcomcred else...