SQL Server how to retrieve all numbers between 2 numbers
<p>I have 4 columns- Code, Amount, Start, End. I would like to take the between amounts in the start and end columns and change them into one column with all results. Any suggestions on how to achieve this? Thanks.</p>

<pre><code>Current Results:
Code  Amount  Start  End
1     5000    2015   2016
2     5000    2014   2016
3     20000   2012   2016

Desired Results:
Code  Amount  StartEnd
1     5000    2015
1     5000    2016
2     5000    2014
2     5000    2015
2     5000    2016
3     20000   2012
3     20000   2013
3     20000   2014
3     20000   2015
3     20000   2016
</code></pre>