title: Display a single record (row) as a single column
body: <p>I'm looking for ways to display a single row of data as a single column (with multiple rows).  For example,</p>
  
  <pre>
  FieldA  FieldB
  ------- ---------
  1       Some Text [row]
  
  
  Header Value [col]
  ------ ------
  FieldA 1          [row1]
  FieldB SomeText   [row2]
  
  </pre>
  
  <p>Is there a way to do this with SQL Server 2005?</p>