title: Date Wise Report in SQL server 2008
body: <p>How to get following output ?</p>
  
  <pre><code>[1],[2],[3],[4],[5],[6],[8],[9],[10],[11],[12],[13],[14],[15],[16],[17]
  ,[18],[19],[20]
  ,[21],[22],[23],[24],[25],[26],[27],[28],[29],[30]
  </code></pre>
  
  <p>Need to fetch all dates from given month in sql server</p>
  
  <p>I want to display daily Date Wise report</p>
  
  <p>Example :
  If I pass date as '11/01/2012' then it should return above result
  and if I pass December than 31 days.</p>