title: Transpose rows to single column
body: <p>I am using SQLServer. I have a query which gives the following result.</p>
  
  <pre><code>1 Apple
  1 Banana
  1 Orange
  </code></pre>
  
  <p>Is there anyway in SQL to traspose it to the following:</p>
  
  <pre><code>1 Apple Banana Orange
  </code></pre>