8 Replies Latest reply on Aug 20, 2018 5:12 AM by Ken Flerlage

    Error: Arithmetic overflow error converting expression to data type int?

    Data Modeler

      In custom SQL, I am writing cast(a.variablename as nvarchar(255)) as variablenameCh. Then I am using this converted variable (called variablenameCh) to do a join to another table where this variable is already in char. However, when to try to run an extract, I am getting an error:

      Arithmetic overflow error converting expression to data type int

       

      Please help with this error. Thank you so much.