title: TSQL Insert Error - String or binary data would be truncated
body: <pre><code>set identity_insert tblindividual ON
  
  insert into tblIndividual (nametitle, individ, lastname, firstname, occupation, employer, active, editor, creationdate)
     select 
         salutation, idnumber, last_name, first_name, occupation, 
         employer, 1, recstatus, GETDATE()
     from 
         i_master 
     where 
         cc_rectype = '1' 
  
  set identity_insert tblindividual OFF
  </code></pre>
  
  <p>Receiving error:</p>
  
  <blockquote>
    <p>Msg 8152, Level 16, State 2, Line 2<br>
    String or binary data would be truncated.
    The statement has been terminated.</p>
  </blockquote>