title: why Pivot is giving error as 'Incorrect syntax near '4721'
body: <p>I have a table like below - </p>
  
  <pre><code>[ID]    [PID]
  1       4721
  2       25
  3       4721
  </code></pre>
  
  <p>And I create a Pivot using the below mentioned Query -</p>
  
  <pre><code>select id,pid
  from #a
  pivot(sum(id) for pid in(4721,25)) as pvt
  </code></pre>
  
  <p>but I am getting error in the above code as - 
  Incorrect syntax near '4721'. I am not able to figure out why. Can you tell me where I am missing. I want the resultant table like - </p>
  
  <pre><code>[4721]  [25]
  4,       2
  </code></pre>