title: Last_value with IGNORE NULLS in SQL Server
body: <p>I have a time series that with null values.  I want to be replace each null value with the most recent non-non value.  From what I've researched, Oracle SQL can easily accomplish this using Last_value with IGNORE NULLS.  Is there a similar way to accomplish this using SQL Server 2016?  Otherwise I'm just going to code it using C#, but felt using SQL would be faster, cleaner, and easier.</p>
  
  <pre><code>Sec SCORE
  1   Null
  2   Null
  3   5
  4   Null
  5   8
  6   7
  7   Null
  </code></pre>
  
  <p>Should be replaced with:</p>
  
  <pre><code>Sec SCORE
  1   Null
  2   Null
  3   5
  4   5
  5   8
  6   7
  7   7
  </code></pre>