title: SELECT records until new value SQL
body: <p>I have a table</p>
  
  <pre><code>Val | Number 
  08    | 1 
  09    | 1 
  10    | 1 
  11    | 3 
  12    | 0 
  13    | 1 
  14    | 1 
  15    | 1 
  </code></pre>
  
  <p>I need to return the last values where Number = 1 (however many that may be) until Number changes, but do not need the first instances where Number = 1.  Essentially I need to select back until Number changes to 0 (15, 14, 13)</p>
  
  <p>Is there a proper way to do this in MSSQL?</p>