title: SQL Server query return next date with an event
body: <p>Basic SQL question but I have a mind blank. I have a table with the following setup:</p>
  
  <pre><code>date          eventType
  -----------------------
  01/01/2016    0
  02/01/2016    0
  03/01/2016    2
  03/01/2016    2
  04/01/2016    6
  04/01/2016    6
  04/01/2016    6
  04/01/2016    6
  05/01/2016    0
  06/01/2016    ...
  </code></pre>
  
  <p>I want to return the "next set of events where eventType&lt;>0"</p>
  
  <p>So, if "today" was 01/01/2016, the query would return:</p>
  
  <pre><code>03/01/2016      2
  03/01/2016      2
  </code></pre>
  
  <p>If "today" was 03/01/2016, the query would return:</p>
  
  <pre><code>04/01/2016      6
  04/01/2016      6
  04/01/2016      6
  04/01/2016      6
  </code></pre>
  
  <p>Etc.</p>
  
  <p>Many thanks</p>