title: SQL group sequence ids and count them (sqlServer)
body: <p>Easy question: Following single table with IDs</p>
  
  <pre class="lang-none prettyprint-override"><code>    IDS
      5
      6
      7
      8
      13
      14
  </code></pre>
  
  <p>What I want</p>
  
  <pre class="lang-none prettyprint-override"><code>    MinID   MaxID   Count
      5       8       4
      13      14      2
  </code></pre>
  
  <p>Any Idea? CTE are my pesonal preferences </p>