[pre]
Dear All,

I have 2 DB. One is in oracle and another is in sql server 2005.
Both have same tables and records.
Problem is that,
I have one view. The script is same in Oracle and SQL server 2005.
But for One calculation i am getting different values.

calculation is:

(CAST(FLOOR(((COALESCE(Factor, 0.0) * TerrRate) * POWER(10.0, 4)) + 0.5 ) as float) / POWER(10.0, 4)) * 100

o/p of sql server is;
---------------------
4.4600
0.8600
0.8000

and o/p of Oracle is;
-----------------------
4.47
0.86
0.8

why I am getting the 0.01 difference???
The values for factor and terrrate is same in both DB.
factor =
-------
0.0084
0.009
0.047

and terrrate =
-------------
0.95
0.95
0.95


Please sone one help me. I am in confusion...
Thanks in advance.

[/pre]