title: Get rows with consecutive Date(Day)
body: <p>I'm searching a way to update all rows which have an other occurence the day before.</p>
  
  <p>Example:</p>
  
  <pre><code>ID     Config Number     Date          Status
  1      238               10/9/2013     1
  2      351               1/9/2013      2
  3      351               2/9/2013      0
  4      238               11/9/2013     0
  5      124               18/9/2013     3
  6      238               20/9/2013     0
  7      238               12/9/2013     0
  8      124               20/9/2013     0
  9      238               13/9/2013     0
  </code></pre>
  
  <p>And after the update i would like to have something like:</p>
  
  <pre><code>ID     Config Number     Date          Status
  1      238               10/9/2013     1
  2      351               1/9/2013      2
  3      351               2/9/2013      2
  4      238               11/9/2013     1
  5      124               18/9/2013     3
  6      238               20/9/2013     0
  7      238               12/9/2013     1 
  8      124               20/9/2013     0
  9      238               13/9/2013     1
  </code></pre>
  
  <p>What i have for now is:</p>
  
  <pre><code>Update sc
  set sc.Status = (Select Status From sc1 inner Join sc On sc.Id = sc1.ID)
  From sc
  </code></pre>
  
  <p>And I know it didn't work, but I can't figure out how should my query should look like.</p>