title: Get number of weekdays (Sundays, Mondays, Tuesdays) between two dates SQL
body: <p>So, I'd like to, for a Start Date and End Date, determine how many particular days of the week occur between these two dates.</p>
  
  <p>So how many mondays, tuesdays, etc</p>
  
  <p>I know I can do this with a loop between the Start and End Date and check each day, but the difference could possibly be a great number of days.  I'd prefer something that didn't require a loop.  Any ideas? (Must be supported in SQL Server 2005+)</p>