title: Get only Saturday and Sunday dates of month in SQL Server
body: <p>Can I find the date of a day that is on which dates the Saturdays and Sundays of a specific month fall? For e.g consider the month of JANUARY-2017. The following dates are weekend days:</p>
  
  <pre><code> 7/1/2017 - Saturday
  14/1/2017 - Saturday
  21/1/2017 - Saturday
  28/1/2017 - Saturday 
   1/1/2017 - Sunday
   8/1/2017 - Sunday    
  15/1/2017 - Sunday
  22/1/2017 - Sunday
  29/1/2017 - Sunday
  </code></pre>
  
  <p>I want a SQL Server query for this such that when I pass in month and year as input, I should get back all the above dates (only dates of Saturday and Sunday) as output</p>
  
  <p>I do not wish to use any user defined function and want to finish it in a single <code>SELECT</code> statement</p>