Monday, February 20, 2012

Percentage returning 0 values

Hi all

im trying to divide 2 columns but when i divide it equals 0. However if i add, subtract or multiple it works fine...

select #all.playerid, #won.wongames, #all.allgame, #won.wongames/#all.allgame as percentage
from #all
left join #won
on #all.playerid = #won.playerid

Thanks in advance.
MehulIm thinking it might be that it does not allow decimals... is there a way to overcome this??

Thanks

No comments:

Post a Comment