title: Incorrect syntax near '1'. Expecting ID, QUOTED_ID, or '.' Error with SQL Pivot
body: <p>I have a table with stats for universities that looks like this:</p>
  
  <pre><code>StatID | UniversityID | StatValue
  1      | 1            | 100
  2      | 1            | 90
  3      | 1            | 80
  1      | 2            | 50
  2      | 2            | 55
  </code></pre>
  
  <p>I'd like a query to return something like this:</p>
  
  <pre><code>(Rows are StatIDs, Columns are UniversityIDs)
  StatID | 1             | 2             | 3
  1      | 100           | 50            | NULL
  2      | 90            | 55            | NULL
  3      | 80            | NULL          | NULL
  </code></pre>
  
  <p>Here's my query:</p>
  
  <pre><code>SELECT StatID, 1, 2, 3
  FROM 
      (SELECT StatID, UniversityID, StatValue FROM @table) up
  PIVOT 
      (MAX(StatValue) FOR UniversityID IN (1, 2, 3)) AS pvt
  ORDER BY StatisticID;
  </code></pre>
  
  <p>I get an error on <code>FOR UniversityID IN (1,</code> saying:</p>
  
  <pre><code>Incorrect syntax near '1'. Expecting ID, QUOTED_ID, or '.'.
  </code></pre>
  
  <p>What am I doing wrong? Does it have something to do with an <code>int</code> as a column header?</p>
  
  <p>I will be using this with ~260,000 rows (~300 columns and ~3,000 rows)</p>