title: getting error on pivot for syntax when converting rows as column
body: <p>i am using sql server and wants my table rows as columns when i convert with this query its give me error on for keyword that </p>
  
  <blockquote>
    <p>Incorrect syntax near '1'.
    this is my query</p>
  </blockquote>
  
  <pre><code>select strvalue,1,2
  from
  (select  strvalue,nSectionAttributeId,
  
  (row_number()  over (partition by nSectionAttributeId  order by nsectionattributeid ) ) as colum
   from tblAttributeData
   )temp
  
   pivot
   (
   max(nSectionAttributeId)
   for colum in (1,2)
   )PIV
  </code></pre>