title: How to display selected results on one row instead of multiple rows in SQL
body: <p>I want to make my MS SQL 2008 select query display results in a very unique way that i hope somebody can help me accomplish.</p>
  
  <p>Instead of having the results for 3 columns being displayed over 9 rows, i would like the data displayed in one row and have the 3 column names repeated 9 times. </p>
  
  <p>I tried to Google this but i can't seem to find the right ideas anywhere.</p>
  
  <p>Thanks a million to anyone that can help!</p>
  
  <p>i wanted to post up pic's but i need rep points to do it which is so stupid! but any way i found a similar post that was answered for PostgreSQL 8.3. but i'm a total beginner so i don't understand how to translate is for MS SQL.</p>
  
  <p>before:</p>
  
  <pre><code>col1 |  col2  |  col3   |
  -----|--------|---------|
   a   |12/01/12| 13/01/12|
  -----|--------|---------|
   b   |14/01/12| 14/01/12|
  </code></pre>
  
  <p>after:</p>
  
  <pre><code>col1 |  col2  |  col3   |col1 |  col2  |  col3   |
  -----|--------|---------|-----|--------|---------|
   a   |12/01/12| 13/01/12| b   |14/01/12| 15/01/12|
  -----|--------|---------|-----|--------|---------|
  </code></pre>
  
  <p>here's the link to give you a better idea of my situation 
  <a href="https://stackoverflow.com/questions/13744386/convert-multiple-rows-into-one-row-with-multiple-columns">Convert multiple rows into one row with multiple columns</a></p>