title: Sql Server: how to transpose row to column?
body: <p>this is (maybe) an already asked question... but i've some difficul to solve my problem. 
  I need to transpose to column a row-based query. 
  I explain: 
  This is my actual query result</p>
  
  <pre><code>Year     Month     Value
  2010      Jan         19
  2010      Feb         10
  ...
  </code></pre>
  
  <p>I need </p>
  
  <pre><code>Year      Jan        Feb         ...         Dec
  2010      19         20          ...         ...
  2011      11         ..          ...           
  </code></pre>
  
  <p>Actually, my main query is very simple..</p>
  
  <pre><code>SELECT     SUM(QTYCALC) AS TOT, YEAR(SCHEDSTART) AS MyYear, MONTH(SCHEDSTART) AS MyMonth
  FROM         PRODTABLE
  GROUP BY YEAR(SCHEDSTART), MONTH(SCHEDSTART)
  </code></pre>
  
  <p>Thanks in advance</p>