title: Unpivot multiple columns and value
body: <p>I have a query with period and three columns, which are of different data types.</p>
  
  <pre><code>abc: int
  def: decimal
  hij: int
  </code></pre>
  
  <p>Data for these three columns provides come from different queries.</p>
  
  <p><em>Here is the current result</em>:</p>
  
  <pre><code>Period    abc   def   hij
  ------    ----  ----  ---
  2012-01    10   0.00    4
  2012-02     5   0.00    5
  2012-03     0   2.40    8
  </code></pre>
  
  <p><em>I would like to get the following output</em>:</p>
  
  <pre><code>abc 2012-01 10 0.00
  abc 2012-02  5 0.00
  abc 2012-03  0 0.00
  def 2012-01  0 0.00
  def 2012-02  0 0.00
  def 2012-03  0 2.40
  hij 2012-01  4 0.00
  hij 2012-02  5 0.00
  hij 2012-03  8 0.00
  </code></pre>
  
  <p>I would like to use unpivot but it gives me an error of conflict type. </p>