title: SQL Count and Sum Over Time
body: <p>I have a set of data that looks like this:</p>
  
  <pre><code> ID         Date
  
  62  2012-06-12 05:30:57.000
  202 2012-06-13 00:00:00.000
  73  2012-06-17 05:25:15.000
  74  2012-06-17 06:20:00.000
  75  2012-06-17 10:46:03.000
  76  2012-06-17 11:15:33.000
  77  2012-06-17 12:17:09.000
  79  2012-06-17 21:12:44.000
  81  2012-06-18 12:34:45.000
  82  2012-06-18 16:46:29.000
  83  2012-06-19 00:21:44.000
  84  2012-06-20 11:31:52.000
  86  2012-06-22 23:27:38.000
  87  2012-06-23 17:02:18.000
  89  2012-06-25 10:05:00.000
  91  2012-06-25 12:36:13.000
  92  2012-06-25 15:28:36.000
  93  2012-06-26 12:16:45.000
  97  2012-06-27 14:03:14.000
  98  2012-06-27 14:20:37.000
  99  2012-06-27 16:21:21.000
  114 2012-06-28 21:58:43.000
  115 2012-06-29 10:46:53.000
  120 2012-07-09 01:11:34.000
  </code></pre>
  
  <p>This goes on for multiple years.</p>
  
  <p>I tried this, but it didn't work:</p>
  
  <pre><code>SELECT COUNT(Q.Questionaire_ID) AS [Count], Q.Start_Date AS [Date]
  FROM Questionaires as Q 
  GROUP BY Q.Start_Date
  </code></pre>
  
  <p>I'm trying to sum each month's count.<br>
  For example if:</p>
  
  <pre><code>Date       Count    Total
  2012-06     10       10
  2012-07     5        15
  </code></pre>