title: Create Temp Table with Range of Numbers
body: <p>I have a table that has rows with the start and end numbers of a range e.g.</p>
  
  <pre><code>key     startID       endID
   1         500        505
   2         784        788
   3         802        804
  </code></pre>
  
  <p>and so on..</p>
  
  <p>I would like to create a temp table (or table variable/cte etc) that has a row for each of these numbers and the range they cover between them - i.e. given the above example I would like to see a table with the following rows:</p>
  
  <pre><code>ID
  500
  501
  502
  503
  504
  505
  784
  785
  786
  787
  788
  802
  803
  804
  </code></pre>
  
  <p>Can anyone point me in the direction of quick and easy way to achieve this? I thought about using a numbers table somehow but the tables I am looking at have > 200m rows and I don't have a numbers table that big!</p>
  
  <p>Any help is much appreciated.  Thanks in advance.</p>