title: SQL - Generate "missing rows" with a select
body: <p>This question relates to SQL 2012 - 
  Lets say I have 3 rows generated as follows:</p>
  
  <pre><code>Start Position = 10
  End Position = 13
  Value = 100
  
  Start position = 14
  End Position = 14
  Value = 250
  
  Start Position = 15
  End Position = 25
  Value = 300
  </code></pre>
  
  <p>on 3 rows .. 
  Is there a way I can force SQL to write the output:</p>
  
  <pre><code>10 - 100
  11 - 100
  12 - 100
  13 - 100
  14 - 250
  15 - 300
  16 - 300
  </code></pre>
  
  <p>etc and so on and so forth</p>
  
  <p>Been wracking the brains but cant  work out an easy way to do it</p>
  
  <p>Thanks a lot </p>
  
  <p>J</p>