title: microsoft sql server - calculate return between every row and the last row
body: <p>I have a table like the following:</p>
  
  <pre><code>+-------+--------------+
  | Value |       Date   |
  +-------+--------------+
  |    14 | 10/11/2010   |
  |    12 | 10/12/2010   |
  |    12 | 10/13/2010   |
  |    10 | 10/14/2010   |
  |    8  | 10/15/2010   |
  |    6  | 10/16/2010   |
  |    4  | 10/17/2010   |
  |    2  | 10/18/2010   |
  +-------+--------------+
  </code></pre>
  
  <p>I would like to calculate the return (the quotient) between every row and the last row (which is with the latest date). e.g for the row with date "10/16/2010", the result should be 6/2=3</p>
  
  <p>Hence, the resulting table should be </p>
  
  <pre><code>+-------+--------------+
  | result|       Date   |
  +-------+--------------+
  |    7  | 10/11/2010   |
  |    6  | 10/12/2010   |
  |    6  | 10/13/2010   |
  |    5  | 10/14/2010   |
  |    4  | 10/15/2010   |
  |    3  | 10/16/2010   |
  |    2  | 10/17/2010   |
  |    1  | 10/18/2010   |
  +-------+--------------+
  </code></pre>
  
  <p>Is it possible to complete this? thanks you!</p>