Error " Runtime Error: Arithmetic overflow error converting expression to data type int" Connecting to MS SQL with Custom SQL

Issue

When connecting to Microsoft SQL Server using custom SQL, the following error might occur:

Runtime Error: Arithmetic overflow error converting expression to data type int.

Environment

Tableau Desktop 8.2
Windows 7
Microsoft (MS) SQL Server

Resolution

Option 1

Change the calculation to return a valid number for the column type in the database.

Option 2

Recreate the calculation, wrapping it in the FLOAT() function

Option 3

Work with the database administrator to recast the BIT type of the column in the original data source.

Cause

The returned value exceeds the maximum memory of the type for the column.

Additional Information

An arithmetic overflow error can occur when there is a calculation in the custom SQL that generates a result that exceeds the limitations of the data type of the column.

Additionally, the following link from Microsoft Technet may provide some insight into this issue: Runtime Error: Arithmetic overflow error converting expression to data type int.