title: Show value of particular column as Header in SQL Server
body: <p>I am creating a web app in which I have a requirement where I want to display a column value as a header</p>
  
  <p>Example</p>
  
  <pre><code>SELECT Name, Leave
  FROM tblUser 
  INNER JOIN tblLeaveMaster ON tblUser.EmployeeID = tblLeaveMaster.EmployeeID
  </code></pre>
  
  <p>From that query, I get these results:</p>
  
  <pre><code>Name     Leave
  ---------------
  Test1       5
  Test2      10
  test3       2
  </code></pre>
  
  <p>Now I want to get these values as </p>
  
  <pre><code>Test1 Test2 Test3
  -----------------
    5     10    2
  </code></pre>
  
  <p>How can I achieve this?</p>