title: SQL Server - Row added via parent table trigger not available in child table trigger
body: <p>I have 3 tables </p>
  
  <ol>
  <li><code>ParentTable</code></li>
  <li><code>ChildTable</code> (with column <code>ParentId</code> refering to <code>ParentTable</code>)</li>
  <li><code>Recording</code> (with column <code>ParentId</code> refering to own table)</li>
  </ol>
  
  <p>Parent table has a trigger which adds a row into the <code>Recording</code> table.</p>
  
  <p>Child table again has a trigger that appends row in <code>Recording</code> table </p>
  
  <p>Now I get an error that the row was not found in <code>Recording</code> table</p>
  
  <blockquote>
    <p>The INSERT statement conflicted with the FOREIGN KEY SAME TABLE
    constraint</p>
  </blockquote>