title: split the value and stores in table
body: <p>I want to create a sql query to split a single column value into multiple rows like: 
    i have two value which split and stored in table from a to b  </p>
  
  <pre><code>create table #density(density decimal (15,2),value decimal (15,2)) 
  
  declare @a    decimal (15,2),
          @b      decimal (15,2),
          @karats         decimal (15,2)
  
  
  set @a='19.99'
  set @b='20.02'
  set @karats='24.00'
  
  
  expected result--
  density      value
  19.99           24
  20.00           24
  20.01           24  
  20.02           24
  </code></pre>