title: "String or binary data would be truncated" during INSERT INTO
body: <p>I have total of 22025 records to be insert from the select list. The error "String or binary data would be truncated" prompt when i execute the below script. While if i add in some where clause to the select list to reduce the number of records to be insert in once, e.g. 10000 records for 1st insertion and 12025 records for 2nd insertion, no error prompt.
  I've checked the length of each field, not exceeding the destination columns' length.
  Please advise. Thanks! </p>
  
  <pre><code>INSERT INTO [BWX] 
  SELECT PK1.STRING_VALUE,PK2.STRING_VALUE,PK3.STRING_VALUE,PK4.STRING_VALUE,
         2000010, BW_ROW.ID AS BW_ROW_ID, BW_ROW.SEQUENCE_NUMBER, 
         0 AS UPDATE_FLAG, 0 AS DELETE_FLAG, BW_ROW.IS_ACTIVE 
  FROM BW_CELL AS PK1, BW_COLUMN AS PK1COL, BW_CELL AS PK2, BW_COLUMN AS PK2COL, 
       BW_CELL AS PK3, BW_COLUMN AS PK3COL, BW_CELL AS PK4, BW_COLUMN AS PK4COL, 
       BW_COLUMN AS PK9COL, BW_ROW 
  WHERE PK1.BW_ROW_ID = BW_ROW.ID AND PK1.PTN_KEY = 100 
        AND PK1.BW_COLUMN_ID = PK1COL.ID AND PK1COL.NAME = 'key_1' 
        AND PK2.BW_ROW_ID = BW_ROW.ID AND PK2.PTN_KEY = 100 
        AND PK2.BW_COLUMN_ID = PK2COL.ID AND PK2COL.NAME = 'key_2' 
        AND PK3.BW_ROW_ID = BW_ROW.ID AND PK3.PTN_KEY = 100 
        AND PK3.BW_COLUMN_ID = PK3COL.ID AND PK3COL.NAME = 'key_3' 
        AND PK4.BW_ROW_ID = BW_ROW.ID AND PK4.PTN_KEY = 100 
        AND PK4.BW_COLUMN_ID = PK4COL.ID AND PK4COL.NAME = 'key_4' 
        AND BW_ROW.BW_TBL_ID = 2000010 AND BW_ROW.IS_ACTIVE = 1 AND BW_ROW.TX_ID &gt; -1 
        AND NOT EXISTS ( SELECT [BWX_ROW@DEVICE_FORECAST].BW_ROW_ID 
                         FROM [BWX_ROW@DEVICE_FORECAST] 
                         WHERE BW_ROW.ID = [BWX_ROW@DEVICE_FORECAST].BW_ROW_ID ) 
  </code></pre>