declare

@d1 decimal(38,10),

@d2 decimal(38,10)

SELECT

@d1 = 1.67574,

@d2 = 10000

SELECT

d1 = @d1,

d2 = @d2,

d1_div_d2 = @d1 / @d2,

cast_div = CAST(@d1 / @d2 AS DECIMAL(38,10)),

num_div = 1.67574 / 10000.0,

cast_num_div = CAST(1.67574 / 10000.0 AS DECIMAL(38,10))

done (i trimed strings to results)

d1 d2 d1_div_d2 cast_div num_div cast_num_div

------------ ---------------- --------- ------------ -------------- ------------

1.6757400000 10000.0000000000 0.000167 0.0001670000 0.000167574000 0.0001675740

:w00t::hehe::crazy::-D