title: SQL query to select dates between two dates
body: <p>I have a <code>start_date</code> and <code>end_date</code>. I want to get the list of dates in between these two dates. Can anyone help me pointing the mistake in my query.</p>
  
  <pre><code>select Date,TotalAllowance 
  from Calculation 
  where EmployeeId=1
    and Date between 2011/02/25 and 2011/02/27
  </code></pre>
  
  <p>Here <code>Date</code> is a <code>datetime</code> variable.</p>