title: SQL Server GROUP BY datetime ignore hour minute and a select with a date and sum value
body: <p>I have a table with two fields - <code>datetime</code> and <code>int</code>. I want to do a group by on the <code>datetime</code> only on the date ignoring the hour and minute. The <code>SELECT</code> statement should return a date that maps to the sum of the int of a single day.</p>