title: SQLServer - Skip wrong rows on insert
body: <p>I'm trying to insert data from a table into another table, the first table is a varchar and the second one is a date.</p>
  
  <p>I know about the <code>convert</code> and almost every row (in the varchar table) has the correct format. But some are wrong. </p>
  
  <p>I have 70000 rows and if I try to insert all of them I got the error "The conversion of a varchar data type to a datetime data type resulted in an out-of-range value." Maybe because a month with 30 days inserted with 31 or maybe a day inserted as 0.</p>
  
  <p><em>What I need is a way to skip the wrong ones and insert the rest, and a way to know what rows are wrong would be super helpful too.</em></p>
  
  <p>Thx guys you rock,</p>