title: The conversion of the varchar value overflowed an int column in sql server 2012
body: <p>I'm getting an error with a query to get data... The error message is: Msg 248, Level 16, State 1, Line 1: The conversion of the varchar value overflowed an int column...
  I cant resolve this problem, so if any one can help me, thanks in advance, Here is My Sql:</p>
  
  <p>This happens when I inserted 3 new joins in the query, I made them BOLD, otherwise it works perfectly...</p>
  
  <pre><code>SELECT DISTINCT 
     ACR_ART_ID, DES_TEXTS.TEX_TEXT AS CRITERIA_DES_TEXT,
     COALESCE(DES_TEXTS2.TEX_TEXT, ACR_VALUE) AS CRITERIA_VALUE_TEXT,
     (DES_TEXTS.TEX_TEXT + ': ' + COALESCE(DES_TEXTS2.TEX_TEXT, ACR_VALUE)) AS CEL_OPIS
  FROM              
     Inventory.dbo.ARTICLE_CRITERIA
  LEFT JOIN 
     Inventory.dbo.DESIGNATIONS AS DESIGNATIONS2 ON DESIGNATIONS2.DES_ID = ACR_KV_DES_ID 
  LEFT JOIN 
     Inventory.dbo.DES_TEXTS AS DES_TEXTS2 ON DES_TEXTS2.TEX_ID = DESIGNATIONS2.DES_TEX_ID
  LEFT JOIN 
     Inventory.dbo.CRITERIA ON CRI_ID = ACR_CRI_ID 
  LEFT JOIN 
     Inventory.dbo.DESIGNATIONS ON DESIGNATIONS.DES_ID = CRI_DES_ID
  LEFT JOIN 
     Inventory.dbo.DES_TEXTS ON DES_TEXTS.TEX_ID = DESIGNATIONS.DES_TEX_ID
  INNER JOIN 
     Inventory.dbo.ART_LOOKUP al ON ARTICLE_CRITERIA.ACR_ART_ID = al.ARL_SEARCH_NUMBER
      AND al.ARL_KIND in (1,3)
  INNER JOIN 
     Inventory.dbo.ARTICLES a ON al.ARL_ART_ID = a.ART_ID and (a.ART_SUP_ID=21 or a.ART_SUP_ID=11091)
  INNER JOIN 
     Inventory.dbo.SUPPLIERS ON SUPPLIERS.SUP_ID = ART_SUP_ID**
  WHERE  
     (DESIGNATIONS.DES_LNG_ID IS NULL OR DESIGNATIONS.DES_LNG_ID = 25)
     AND (DESIGNATIONS2.DES_LNG_ID IS NULL OR DESIGNATIONS2.DES_LNG_ID = 25);
  </code></pre>