title: How to fetch Rows as columns in SQL Server
body: <p>Hi I trying to fetch and display some rows as columns. I dont have any idea how to implement this, but in demand. Here is my table columns</p>
  
  <pre><code>**GameDate   StuName      GameName  Participation**
  10/10/15   Srini        Football     yes
  10/10/15   srini        Hockey       no
  10/10/15   srini        Cricket      yes
  10/10/15   dev          Football     no
  10/10/15   dev          Hockey       yes
  10/10/15   dev          Cricket      yes
  
  I want result set as 
  
  **GameDate   StuName    FootBall  Hockey  Cricket**
  10/10/15     Srini        yes      no       yes
  10/10/15     dev          no       yes      yes
  </code></pre>
  
  <p>Please help me. Thanks in advance</p>