title: Arithmetic overflow error for type int
body: <p>I'm currently getting this error when do a select on a table </p>
  
  <p>Arithmetic overflow error for type int, value = 4318826193.000000.</p>
  
  <p>I'm trying to figure out what column is causing this , what is the best way to figure out what column is causing this problem with this value 4318826193.000000  ? </p>
  
  <p>I've tried writing a select statement with all the INT columns with a CAST( [column name] as bigint) but the error still appears. </p>
  
  <pre><code> SELECT
         CAST(Id AS BIGINT)
        ,CAST (CreatedBy as BIGINT)
        ,CAST (UpdatedBy as BIGINT)
        ,CAST (HeaderId as BIGINT)
        ,CAST (DiskFileId as BIGINT)
        ,CAST (Status as BIGINT)
        ,CAST (TotalLines as BIGINT)
        ,CAST (CompletedLines as BIGINT)
        ,CAST (ProcessedLines as BIGINT)
        ,CAST (PercentComplete as BIGINT)
        ,CAST (SecondsRemaining as BIGINT)
        ,CAST (RollbackUser as BIGINT)
        ,CAST (CreatedRecords as BIGINT)
        ,CAST (UpdatedRecords as BIGINT)
        ,CAST (SkippedRecords as BIGINT)
        ,CAST (DiallerExportProgress as BIGINT)
        ,CAST (idxCampaignId as BIGINT)
        ,CAST (ScheduleId as BIGINT)
        ,CAST (CampaignId as BIGINT)
  
   from [table_name]
  </code></pre>
  
  <p>Thanks</p>