Forum Replies Created

Viewing post 1 (of 1 total)

  • RE: Divide by 2.1 Billion

    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

Viewing post 1 (of 1 total)