Prev: SELECT * FROM @Table not using Dynamic SQL (if exists)
Next: CONMON Database please
From: LUIS on 4 Jul 2008 18:24

--
Luis Garcia
IT Consultant
From: LUIS on 4 Jul 2008 18:36
I have found that ROUND() command are different among MS products (VB, SQL,
Excel, VBA, etc) in versions like (Banker's Rounding, Random Rounding,
Rounding Up, Rounding Down, etc.)
In my Apps, I use VB6 and MSSQL 2000, arithmetic operations were done in
both plataforms (not crazy way until I notice this...). THAT IS THE PROBLEM.
SOLUTIONS:(Please advise me)
1. Use only one plataform for arithmetic operations (Best).
2. Create a function that invoke a SP which returns ROUND() from SQL (Does
it decrease or impact performance?)
3. Other

Beforehand, thank you very much.

--
Luis Garcia
IT Consultant


"LUIS" wrote:

>
> --
> Luis Garcia
> IT Consultant
 | 
Pages: 1
Prev: SELECT * FROM @Table not using Dynamic SQL (if exists)
Next: CONMON Database please