title: sql server - query. Returning time between failures
body: <p>I have details on what builds passed and what builds failed. I want to be able to measure the time in between failures (meaning there is at least 1 pass in between 2 failures). I have example data and example queries I have so far linked <a href="http://rextester.com/IPB58958" rel="nofollow">here</a>.</p>
  
  <p>What I want my query to output given this data is just 2 rows</p>
  
  <pre><code>FailedDt             |        SecondFailedDt
  -------------------------------------------------
  
  1/2/2010 12:00:00 AM |        1/4/2010 12:00:00 AM
  
  1/6/2010 12:00:00 AM |        1/10/2010 12:00:00 AM
  </code></pre>
  
  <p>How can I modify my query to get the output I want?</p>