title: how do you pivot sql data without aggregating a column
body: <p>I have the following output in a query.</p>
  
  <pre><code>SKILL                                              LEVEL          SCORERANGE
  -----------------------------------------------------------------------------
  Stunts                                             LOW            0.0 - 4.0
  Stunts                                             MED            3.0 - 7.0
  Stunts                                             HI             6.0 - 10.0
  Pyramids                                           LOW            0.0 - 4.0
  Pyramids                                           MED            3.0 - 7.0
  Pyramids                                           HI             6.0 - 10.0
  Tosses                                             LOW            0.0 - 4.0
  Tosses                                             MED            3.0 - 7.0
  Tosses                                             HI             6.0 - 10.0
  Standing Tumbling                                  LOW            0.0 - 4.0
  Standing Tumbling                                  MED            3.0 - 7.0
  Standing Tumbling                                  HI             6.0 - 10.0
  Running Tumbling                                   LOW            0.0 - 4.0
  Running Tumbling                                   MED            3.0 - 7.0
  Running Tumbling                                   HI             6.0 - 10.0
  Jumps                                              LOW            0.0 - 4.0
  Jumps                                              MED            3.0 - 7.0
  </code></pre>
  
  <p>I want to PIVOT this data without aggregating anything.  So I want a result that shows only one row for each skill and pivots the LEVEL, something like this...  </p>
  
  <pre><code>SKILL                                              LOWRANGE       MEDRANGE       HIRANGE 
  Stunts                                             0.0 - 4.0      3.0 - 7.0      6.0 - 10.0
  Pyramids                                           0.0 - 4.0      3.0 - 7.0      6.0 - 10.0
  Tosses                                             0.0 - 4.0      3.0 - 7.0      6.0 - 10.0
  Standing Tumbling                                  0.0 - 4.0      3.0 - 7.0      6.0 - 10.0
  Running Tumbling                                   0.0 - 4.0      3.0 - 7.0      6.0 - 10.0
  ...
  </code></pre>
  
  <p>I do have a pretty good understanding of basic pivot syntax but I am struggling with this one because there is nothing to aggregate in the result set.  </p>
  
  <p>To give you something to try to fix for me...</p>
  
  <pre><code>SELECT SKILL, LOWRANGE, MEDRANGE, HIRANGE
  FROM (SELECT SKILL, [LEVEL], SCORERANGE FROM ScoreRanges) ps
  PIVOT 
      (
          MAX(SCORERANGE)  --THIS IS PROBABLY WRONG
          FOR SCORERANGE IN
          (
             --SOMETHING GOES HERE
          )
      ) as pvt
  </code></pre>
  
  <p>Thanks for your help.  </p>
  
  <p>Seth</p>