title: How to find N Consecutive records in a table using SQL
body: <p>I have the following Table definition with sample data. In the following table, Customer Product &amp; Date are key fields</p>
  
  <pre><code>Table One
  Customer   Product    Date         SALE
     X          A       01/01/2010    YES
     X          A       02/01/2010    YES
     X          A       03/01/2010    NO
     X          A       04/01/2010    NO
     X          A       05/01/2010    YES
     X          A       06/01/2010    NO
     X          A       07/01/2010    NO
     X          A       08/01/2010    NO
     X          A       09/01/2010    YES
     X          A       10/01/2010    YES
     X          A       11/01/2010    NO
     X          A       12/01/2010    YES
  </code></pre>
  
  <p>In the above table, I need to find the N or > N consecutive records where there was no sale, Sale value was 'NO'
  For example, if N is 2, the the result set would return the following</p>
  
  <pre><code>     Customer   Product    Date         SALE
         X          A       03/01/2010    NO
         X          A       04/01/2010    NO
         X          A       06/01/2010    NO
         X          A       07/01/2010    NO
         X          A       08/01/2010    NO
  </code></pre>
  
  <p>Can someone help me with a SQL query to get the desired results. I am using SQL Server 2005. I started playing using ROW_NUMBER() AND PARTITION clauses but no luck.
  Thanks for any help</p>