Was gonna post this question, but found the answer, so maybe it will help
someone save some time
The following:
1. Select 141/207 returns 0
2. Select Convert(float,141/207) returns .00000
This is because SQL does the math first for the division, and apparently
treats anything less than one as zero, when the dividend and divisor are
integers.
So you need to do this Select Convert(float,141)/Convert(float,207)
Unless of course the data you are using is already not an integer.
Have a happy day....
John
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
