title: Add new column to temp table based on values from a column
body: <p>I would like to create a temp table from the below table.</p>
  
  <pre><code>------------------------|--------
  Date                    | Length
  ------------------------|--------
  2014-08-28 00:00:00.000 | 1.5 
  2014-08-28 00:00:00.000 | 2.6
  2014-08-28 00:00:00.000 | 1.5
  2014-08-28 00:00:00.000 | 3.3
  2014-08-28 00:00:00.000 | 1.1
  2014-08-28 00:00:00.000 | 8.5
  2014-08-28 00:00:00.000 | 8.6
  2014-08-28 00:00:00.000 | 11.3
  </code></pre>
  
  <p>And have the temp table look like the one below. </p>
  
  <pre><code>Date                    | Length  | Length_Range
  ------------------------|---------|--------------
  2014-08-28 00:00:00.000 |  1.5    |   1-4
  2014-08-28 00:00:00.000 |  2.6    |   1-4
  2014-08-28 00:00:00.000 |  6.5    |   5-10
  2014-08-28 00:00:00.000 |  3.3    |   1-4
  2014-08-28 00:00:00.000 |  1.1    |   1-4
  2014-08-28 00:00:00.000 |  8.5    |   5-10
  2014-08-28 00:00:00.000 |  8.6    |   5-10
  2014-08-28 00:00:00.000 |  11.3   |   11-15
  </code></pre>
  
  <p>I would like to be able to define the [Length_Range].</p>
  
  <p>Microsoft SQL Server 2016.
  Compatibility level: SQL Server 2005 (90)</p>