title: How do rank records that exceed a 5 minute interval T-SQL
body: <p>I have the following dataset:</p>
  
  <pre><code>Henry   2014-10-24 00:02:28.000 1.00
  Henry   2014-10-24 00:07:28.000 2.00
  Henry   2014-10-24 00:12:28.000 1.00
  Henry   2014-10-24 00:17:28.000 1.00
  Henry   2014-10-24 00:22:28.000 4.00
  Henry   2014-10-24 00:27:28.000 1.00
  Henry   2014-10-24 01:44:28.000 2.00
  Henry   2014-10-24 01:49:28.000 1.00
  Henry   2014-10-24 01:54:28.000 1.00
  </code></pre>
  
  <p>Rows 1 to 6 are at a 5 minute interval, and then from 7 to 9 they jump an hour. This could vary, and what I would like to do is detect when a dataset breaks the 5 minute interval. I am looking at DENSE_RANK and ROW_NUMBER but not sure if this is the right direction.</p>
  
  <p>Any help would be appreciated.</p>
  
  <p>Thank you.</p>