return a double from integer divide?

Question

Post reply

return a double from integer divide?

blueskies

Newbie

Points: 7
More actions
August 8, 2006 at 4:18 pm

#61074

I'm doing a calculation in a select from which I need a double returned:
SELECT SUM( RiderCount)/Count(*) as RiderAvg
but RiderAvg is returned as a whole number. Is there a function or other method I can use to get this result?
Thanks much.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Aaron Ingold SSCrazy Eights Points: 9070 More actions · Answer 1

SELECT SUM(CONVERT(double, RiderCount)) / count(*) as RiderAvg

blueskies Newbie Points: 7 More actions · Answer 2

blueskies

Newbie

Points: 7

August 8, 2006 at 7:10 pm

#653964

Thanks, that's what I was looking for!

Scott Coleman One Orange Chip Points: 27452 More actions · Answer 3

Why do a CONVERT on every row? CONVERT the SUM instead:

SELECT

CONVERT(double, SUM(RiderCount)) / count(*) as RiderAvg

blueskies Newbie Points: 7 More actions · Answer 4

Thanks for the optimization. How about using CAST instead of CONVERT, is there preference for one over the other?

Thanks.

Scott Coleman One Orange Chip Points: 27452 More actions · Answer 5

I am not aware of any performance difference. I find CAST more readable, but CONVERT provides an extra Style parameter to control formatting. Use whichever one makes you happy.