Viewing post 1 (of 1 total)
You will need to convert to numeric and use a decimal(38.2) conversion.
convert(decimal(38,2),convert(decimal(38,2),sum(cast([Field] as numeric))) / convert(decimal(38,2),count(*))) as Total
October 8, 2015 at 12:06 pm
#1832387