title: Select All dates between two dates
body: <p>I have a table that has only one record as below</p>
  
  <pre><code>Date1            Date2           Amount       CountDays
  2014-01-01       2014-01-4       1000           4
  </code></pre>
  
  <p>field "CountDays" will be calculatd by a trigger. i want to write a query that returns below result:</p>
  
  <pre><code>Date             Amount
  2014-01-01       250
  2014-01-02       250
  2014-01-03       250
  2014-01-04       250
  </code></pre>
  
  <p>it is really neccessary for me please help me.</p>