gcarter@acm.org wrote:

> Below are the results of AxBxCxD on 2 records 9609 and 9610 using
> Transact-SQL. As you can see for record 9609 the Excel result matches
> the Sybase result. However, the results differ for record 9610. Is this
> a precision/rounding issue?
>
> Thanks,
> GC
>
>
>
> RecordNo 9609 9610
> A -13.179101 -7.655611
> B 1.437439 14.195282
> C 0.9998 0.988299
> D 200000000 50000000
> Excel Results -3,788,072,986.3173 -5,370,098,386.8263
> Sybase Results -3,788,072,986.3173 -5,370,099,582.2354
> Diff 0.0000 1,195.4091

yes. if you expect a DBMS to do math, you must use exact
decimal column types, and for the Sybase table, you are
not.
Joe Weinstein at BEA Systems