title: INSERT statement conflicted with the FOREIGN KEY constraint even after deleting the records from the child table
body: <p>I tired to delete the occurrences of the values which the insert stmt was trying to insert 
  in the dependent table. </p>
  
  <pre><code>delete from BSC_UR_RE_AN 
  where AN_ID in (1084,1083,1088,1087,1121,1122,1123,1094,5010,
                  1239,1242,70187,7001,7002,1284,1285)
  </code></pre>
  
  <p>But no luck, I got the following error:</p>
  
  <blockquote>
    <p>The INSERT statement conflicted with the FOREIGN KEY constraint
    "BSC_U_RA_AN_FK".  The conflict occurred in database "DMDB", table
    "dbo.BSC_AN", column 'AN_ID'.</p>
  </blockquote>