title: rename columns in SQL Query transpose
body: <p>I have a SQL query than transpose rows by columns but i dont know how to rename the columns.</p>
  <pre><code>select * 
  from 
      (select CustomerID, FiscalPeriod, SaleAmtLocalCurr  
       from PerfTrk.dbo.IRIS_SaleFact 
       where CountryCode = '00001' 
         and DivisionCode = 'INS' 
         and SaleAmtLocalCurr &gt; 0 
         and datefromparts(FiscalYear, FiscalPeriod, 1) between datefromparts(2019,9, 1) and  datefromparts(2020,8, 31)) d
  pivot 
      (sum(SaleAmtLocalCurr) for FiscalPeriod in ([1], [2], [3], [4], [5], [6], [7], [8], [9], [10], [11], [12]) 
      ) piv;
  </code></pre>
  <p>The result is</p>
  <pre><code>CustomerID 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12
  </code></pre>
  <p>I want to rename the columns with the names of months</p>
  <p>Thanks</p>