title: Strange error upon insert in SQL
body: <p>This process is part of one where I take fields from a 96 column table and place them in a 26 column table (directory). Yrqtr is a field in the table, equi. </p>
  
  <p>I am getting the following error message. I am only confused because yrqtr is not in either statement. any ideas why this one is coming up?</p>
  
  <p>Msg 515, Level 16, State 2, Line 1
  Cannot insert the value NULL into column 'yrqtr', table 'wid27.dbo.directory'; column does not allow nulls. INSERT fails.</p>
  
  <pre><code>   Insert into dbo.directory(state,account,unit,name1,name2,address1,address2,city,st,zip,zipext,addressty,geo1,geo2,telephone,employment,ownership,naicscode,siccode,area)
  
     Select state,account,unit,name1,name2,address1,address2,city,st,zip,zipext,addressty,geo1,geo2,telephone,employment,ownership,naicscode,siccode,area
     From dbo.equi Where something !=2
  </code></pre>