title: SQL - How to get a complete month calendar table
body: <p>I need to generate a report that will show 7 Columns Monday to Sunday and 5 Rows, just like a normal month calendar:</p>
  
  <p><img src="https://i.stack.imgur.com/eGuJv.png" alt="enter image description here"></p>
  
  <p>I need the dates in a list table, so the desire table result should look like this:</p>
  
  <p><img src="https://i.stack.imgur.com/9QqS8.png" alt="enter image description here"></p>
  
  <p>That way my report designer will automatically create a view like above.</p>
  
  <p>The above table result should be generated on the fly with no need of any database table because after this I will have to left join the dates to one of my db tables so I can populate other kind of information that I will use to display in my report for each day.</p>
  
  <blockquote>
    <p>Any clue?</p>
  </blockquote>