title: Pivoting in Sybase SQL Query?
body: <p>I am looking for a way to pivot the following results...</p>
  
  <pre><code>ID | Group_Level | Group_Values
  1  | Division    | Value 1 
  2  | Department  | Value 2
  3  | Class       | Value 3
  </code></pre>
  
  <p>Into the following structure....</p>
  
  <pre><code>ID | Division | Department | Class
  1  | Value 1  | Value 2    | Value 3    
  2  | Value 1  | Value 2    | Value 3
  </code></pre>
  
  <p>The number of columns is fixed (it will always be division/department/class).  The query is intended for Sybase... have been unable to figure out how to achieve this sort of pivoting yet.  Any advice?</p>