title: Sum daily total by category in MSSQL
body: <p>Hi every one I have a database something like following:</p>
  
  <pre><code>TransactionID     DateTime        Amount      Country
  -----------------------------------------------------
  T123456           2013-05-01         100           US
  T123457           2013-05-01         150           US
  T123458           2013-05-01         200           CN
  T123459           2013-05-01         250           CN
  T123460           2013-05-02         250           TW
  T123461           2013-05-02         350           ID
  T123462           2013-05-02         200           TW
  T123463           2013-05-02          50           ID
  T123464           2013-05-02         250           TW
  T123465           2013-05-03         450           TW
  T123466           2013-05-03         350           ID
  T123467           2013-05-03         200           TW
  T123468           2013-05-03         150           CN
  T123469           2013-05-03         350           US
  </code></pre>
  
  <p>Is it possible to use MSSQL to produce the following result?</p>
  
  <pre><code>DateTime        Amount      Country
  -----------------------------------
  2013-05-01         700        Total
  2013-05-01         450           CN
  2013-05-01         250           US
  2013-05-02        1100        Total
  2013-05-02         700           TW
  2013-05-02         400           ID
  2013-05-03        1500        Total
  2013-05-03         650           TW
  2013-05-03         350           ID
  2013-05-03         350           US
  2013-05-03         150           CN
  </code></pre>
  
  <p>Thanks.</p>