var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Wrong result in query statement how to fix?!!
The query is (Select (25/20*100))
The wrong giving result is 100 it's should be 125
How I can use a query statement to get a correct result?
select convert(float, 25)/convert(float, 20) * 100
You are getting wrong value because it is doing a int/int which rounds off to 1(select 25/20). Using the .0 or the convert funtion puts it into a float which will give you 1.25.
Supply the .0's will force it to do real number math.
Supplying the .0's will force it to do real number math.
thank you very much...My Name Is Mohamed Ashour
Nice to meet you