Division of 2 numbers using CAST function in SQL server 2008R2 -


i have 2 numbers want divide: 5262167 / 162333331 when verified using windows calculator (calc.exe) result 0.0324158136076195 when used simple select cast function in sql server 2008r2 don't have same result. here i'm running in sql editor: 

select cast((5262167 / 162333331) decimal(18,8))

and result 0.00000000

you're doing integer division, truncate remainders. 5262167 < 162333331, result 0. cast input before dividing.

select cast(5262167 decimal(18,8)) / cast(162333331 decimal(18,8))

Comments

Post a Comment

Popular posts from this blog

c# - Operator '==' incompatible with operand types 'Guid' and 'Guid' using DynamicExpression.ParseLambda<T, bool> -

i'm using dynamic linq library , there source code , basic docu , nuget version pm> install-package dynamiclinq i'm trying construct clause involves guids i have tried string "id == @0" . parameter array object[] value ( guid xxxx ) var whereclausesb = buildlogicalkeywhereclause2(entity, logicalkey); //build string var parms = buildparamarray(entity, logicalkey); // object[] var wherelambda = ofsi.bos.core.dynamicexpression.parselambda<t, bool>(whereclausesb.tostring(),parms); //parse an exception thrown in dynamicexpression.parselambda operator '==' incompatible operand types 'guid' , 'guid' i have tried guid , string.(fail) i tried , "id = @0" (fail). string == string works, int32==int32 not guid == guid not any ideas? try using equals method instead of == operator in string: "id.equals(@0)"
Read more