title: how to find employee who is absent continuously more than 10 days?
body: <p>I have a table name Att. which has 2 columns: EmpID and Date.
  the date column contains all the dates an employee is present.
  i need write a query to find if any employee is <strong>continuously</strong> absent for more than 10 days.</p>
  
  <pre><code>EmpID | Date
    101 | 1/1/2012
    101 | 2/1/2012
    101 | 7/1/2012
    101 | 18/1/2012
    101 | 21/1/2012
    101 | 25/1/2012
    101 | 30/1/2012
    102 | 1/1/2012
    102 | 2/1/2012
    102 | 5/1/2012
    102 | 9/1/2012
    102 | 14/1/2012
    102 | 19/1/2012
    102 | 24/1/2012
    102 | 25/1/2012
    102 | 28/1/2012
    102 | 29/1/2012
    102 | 30/1/2012
  </code></pre>
  
  <p>the result should 101 here.
  how this can be done? please help.</p>