title: SQL Query for getting nth Weekday date between two dates
body: <p>My scenario is as below:</p>
  
  <pre><code>@StartDate = 13th of current month
  @EndDate = 12th of next month.
  </code></pre>
  
  <p>I want to get all the date with the day-name for Mondays, Tuesdays, Wednesdays, Thursdays, Fridays, Saturdays and Sundays lying between the start and end date.</p>