Hi. i can able to get what i am expected when i use the below code
Declare @real Decimal(15,7)
Set @real=19.005
print ROUND(@real + CAST(0.5E * POWER(0.1E, 2) AS DECIMAL(15, 3)), 2, 1)
Output = 19.01
i am not able to predict the length of the digit after dot, it may vary. so the length of the decimal used while casting should not be hard-coded.
i cant able to supply the length at runtime like decimal(15,@n+1).
Thanks,
Idris Gani R