title: How to count number of records per day?
body: <p>I have a table in a with the following structure:</p>
  
  <pre><code>CustID --- DateAdded ---
  
   396       2012-02-09 
   396       2012-02-09 
   396       2012-02-08 
   396       2012-02-07 
   396       2012-02-07
   396       2012-02-07 
   396       2012-02-06
   396       2012-02-06
  </code></pre>
  
  <p>I would like to know how I can count the number of records per day, for the last 7 days in SQL and then return this as an integer.</p>
  
  <p>At present I have the following SQL query written:</p>
  
  <pre><code>SELECT * 
    FROM Responses
   WHERE DateAdded &gt;= dateadd(day, datediff(day, 0, GetDate()) - 7, 0)
  
  RETURN
  </code></pre>
  
  <p>However this only returns all entries for the past 7 days. How can I count the records per day for the last 7 days?</p>