# SQL Server: Arithmetic overflow error converting expression to data type int. (Msg 8115)

**Code:** `8115` · **Category:** SQL · **Seen on:** SQL

A value or calculation exceeds the target data type’s range.

## Meaning

SUM/COUNT over large data exceeding int, numeric precision too small, or converting large numbers into smaller types.

## Common causes

- SUM of int values exceeding 2,147,483,647
- numeric(p,s) too small
- Converting large values to smaller types

## Quick fix

1. Cast to bigint before aggregating
2. Use COUNT_BIG
3. Increase numeric precision

## Detailed fix by platform

### SQL

1. `SELECT SUM(CAST(Amount AS bigint)) FROM dbo.Payments;`

## How to diagnose

1. **Expression** — Which conversion/aggregate?
2. **Recent change** — Did it start after a deploy, upgrade, or configuration change? Compare with the last working version.

---
Source: [WhatIsMyError](https://whatismyerror.com/errors/sql/mssql-arithmetic-overflow-8115)
