Sql Server is rounding the value while calculating average

Asked Nov 05 '20 at 12:40

Active Nov 05 '20 at 12:46

Viewed 122 times

I am trying to calculate average and the apply CEILING on the average, but somehow when i calculate average it is always rounding off the value.

DECLARE @AverageStudents INT
SELECT @AverageStudents = CEILING((SELECT @TotalUsersInAllScools + @TotalUsersInAllColleges AS FLOAT) + (SELECT @TotalSchools + @TotalUsersColleges AS FLOAT))
SELECT @AverageStudents AS 'AverageStudents'

In my case @TotalUsersInAllScools + @TotalUsersInAllColleges = 875 , and @TotalSchools + @TotalUsersColleges = 216

875/216 = 4.0509 and CEILING of it should give me output 5 but its giving 4.

What i observed is @TotalUsersInAllScools + @TotalUsersInAllColleges AS FLOAT) + (SELECT @TotalSchools + @TotalUsersColleges AS FLOAT)is giving output as 4

edited Nov 05 '20 at 12:41

Thom A

88,727
11
45
75

asked Nov 05 '20 at 12:40

user3198688

What are the datatypes of your variables. I bet they are an `int`. – Thom A Nov 05 '20 at 12:43
yeah they are INT – user3198688 Nov 05 '20 at 12:44
An expression that uses an `int` returns an `int`, so it would be impossible to return `4.0509`. `875/216=4` when you were dealing with `int`s. – Thom A Nov 05 '20 at 12:44

Sql Server is rounding the value while calculating average

0 Answers0