title: How do I exclude Weekend days in a SQL Server query?
body: <p>How do I exclude values in a <code>DateTime</code> column that are Saturdays or Sundays?</p>
  
  <p>For example, given the following data:</p>
  
  <pre><code>date_created
  '2009-11-26 09:00:00'  -- Thursday
  '2009-11-27 09:00:00'  -- Friday
  '2009-11-28 09:00:00'  -- Saturday
  '2009-11-29 09:00:00'  -- Sunday
  '2009-11-30 09:00:00'  -- Monday
  </code></pre>
  
  <p>this is the result I'm looking for:</p>
  
  <pre><code>date_created
  '2009-11-26 09:00:00'  -- Thursday
  '2009-11-27 09:00:00'  -- Friday
  '2009-11-30 09:00:00'  -- Monday
  </code></pre>
  
  <p>Thanks!</p>