title: SQL Server output using Pivot
body: <p>Table detail</p>
  
  <pre><code>Column_name     Type
  -------------------------
  Id              int
  ProductId       int
  Product         nvarchar
  ProductDetails  nvarchar
  </code></pre>
  
  <p>Table data</p>
  
  <pre><code>Id  ProductId   Product ProductDetails
  ---------------------------------------
  1   1           Name    IPhone
  2   1           Price   40000
  3   2           Name    Nokia
  4   2           Price   20000
  </code></pre>
  
  <p>I want result using pivot like this:</p>
  
  <pre><code>Product Price
  -------------
  IPhone  40000
  Nokia   20000
  </code></pre>