title: How to find exact row where SQL query fail
body: <p>I'm using SQL Server 2008 R2. I have 2 tables <code>old</code> and <code>new</code> and about 500k rows.</p>
  
  <p>I need to convert data from <code>old</code> to <code>new</code>. Some columns were changed. For example in <code>old</code> table many columns are of type <code>varchar</code> and in <code>new</code> table <code>int</code>.</p>
  
  <p>I'm executing query like this:</p>
  
  <pre><code>INSERT INTO new (xxx)
      SELECT FROM old (yyy)
  </code></pre>
  
  <p>And get following error:</p>
  
  <blockquote>
    <p>Msg 245, Level 16, State 1, Line 4<br>
    Conversion failed when converting the nvarchar value 'Tammi ' to data type int.</p>
  </blockquote>
  
  <p>This error shows, that in <code>old</code> table are some rows with wrong data in columns. (Human factor).  </p>
  
  <p>But how can I find these wrong rows? Is it possible?</p>
  
  <p>How can I find in what column wrong data is present?</p>