I want to know that, why second and 4th fields are not same?
I convert the sum of two field then divide it by 1000000 on second field, but on 4th field I don't convert it. First and third fields are same as you see and did same operation on them but got different results.
Are you unhappy with my answer? It was a serious response that you had your finger on the answer from the start.
You do know that if you have an integer as both a nominator and denominator you end up with an integer as the result? And that if you have a decimal as either the nominator or denominator you end up with a decimal as the result? I foget the proper name for this, but the result will be the highest precision data type of the nominator and denominator.
That is ok with your answer. I realize important point with your help. I am new with T-SQL but I have to solve problems quickly so I wrote to here.
I saw difference with statement shown below.