An average of integers is an integer unless you convert them to another numeric datatype that allows decimals. ESquared showed one way. Converting to DECIMAL(4,2) should work also.
Thanks ESquared. Your suggestion worked. I had tried something similar to that with the float but the syntax must have been wrong because it didn't work.
I had already tried converting it to a decimal but I got an error message that said:
Arithmetic overflow error converting numeric to data type numeric.
Precision can be very misleading with decima. Float is probably a better way to go to maintain the best final precision, even if converting to decimal at the end.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.