title: How to make Single Column into Rows in Sql Server 2008 R2?
body: <p>Hi i am in confusing state to run an Sql Query, My table looks like this</p>
  
  <p><img src="https://i.stack.imgur.com/yu7I2.png" alt="enter image description here"></p>
  
  <p>from the above image there are two columns. First column consists of Register No of the student. Second Column Consists his/Her Exam Results.<strong>P</strong> States he is passed in the Certain Subject.In the report i want result set like the below. If the Result consists any number he is failed in the following subject.</p>
  
  <ul>
  <li><strong>1--->English   2--->Sanskrit   3--->Maths   4--->Science   5--->Social</strong></li>
  </ul>
  
  <p>i want the result should be like this. Can any body help me in this. i am not getting any idea.</p>
  
  <p><img src="https://i.stack.imgur.com/TU0MO.png" alt="enter image description here"></p>