title: select where not exists excluding identity column
body: <p>I am inserting only new records that do not exist in a live table from a "dump" table. My issue is there is an identity column that I don't want to insert into the live, I want the live tables identity column to take care of incrementing the value but I am getting an insert error "Insert Error: Column name or number of supplied values does not match table definition."  Is there a way around this or is the only fix to remove the identity column all together?</p>
  
  <p>Thanks,
  Sam</p>