title: SQL Server 2008: Pivot column with no aggregate function workaround
body: <p>Yes I know, this question has been asked MANY times but after reading all the posts I found that there wasn't an answer that fits my need. So, Heres my question. I would like to take a column of values and pivot them into rows of 6 columns.</p>
  
  <pre><code>I want to take this......    And turn it into this.......................
  G                            Letter  Date    Code  Ammount   Name       Account 
  081278                       G       081278   12   00123535  John Doe   123456
  12
  00123535
  John Doe
  123456
  </code></pre>
  
  <p>I have 110000 values in this one column in one table called TempTable. I need all the values displayed because each row is an entity to itself. For instance, There is one unique entry for all of the Letter, Date, Code, Ammount, Name, and Account columns. I understand that the aggregate function is required but is there a workaround that will allow me to get this desired result?</p>