On Wed, 23 Apr 2008 13:49:49 -0700 (PDT), Seguros Catatumbo wrote:
>
>> I can't test because I have no access to your tables and test data, but
>> try if the followiing does what you need:
>
>Table CLPF08 sample data and relevant field information:
>
>RAMO POLIZA CERVEH CODCOB MONTO1
>31 6100265 2 1 20.15
>31 6100265 2 2 30.10
>31 6100265 2 3 15.02
>
>Table ARYSAUTO sample data and relevant field information:
>
>CERVEH PRIMA
> 2 65.26
>
>My query shows a 0.01 monetary units of difference, since
>20.15+30.10+15.02 is not exactly 65.26
Hi Seguros,
I expect that this is a rounding issue. What data types are the various
columns?
>Thanks for your help, i hope that this information is enough to fix
>this
No, it isn't. As I already stated in my previous reply, I need to know
the table structure ===> as a CREATE TABLE statement <===. I failed to
include that you also need to include all the constraints, properties,
and indexes (you may omit irrelevant extra columns though).
I also need the sample data ===> as INSERT statements <===. And I need
to know the expected results based on the sample data given.
--
Hugo Kornelis, SQL Server MVP
My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis
|
