I've created a temp table with an int type field on which I am then trying to perform an AVG. I get:

Server: Msg 8115, Level 16, State 2, Line 1

Any ideas?

It would be better if you can post your table DDLs & the entire error
message. It is possible that you have a data type conversion error, in which
case you may want to CAST or CONVERT the datatype to appropriate compatible
one.

--
Anith