title: Finding grand total of day wise total monthly sale
body: <p>in rows i have months. In columns i have 1 to 31 days.
  I want to add a column at the end  Sum  of all sale  sale in the 31 days of a month.</p>
  
  <pre><code>SELECT * FROM (
      SELECT DATENAME(month, date) AS SaleMonth,
          DATEPART(dd,date) AS SaleDay FROM EnquiryMaster
      ) p PIVOT 
      (COUNT (SaleDay) FOR 
      SaleDay IN ( [1],[2],[3],[4],[5],[6],[7],[8],[9],[10],
                  [11],[12],[13],[14],[15],[16],[17],[18],[19],[20],
                  [21],[22],[23],[24],[25],[26],[27],[28],[29],[30],[31] )) AS pvt
  </code></pre>
  
  <p>This code displays day wise data of 31 days but doesnt display sum.</p>