sql server - getting error on pivot for syntax when converting rows as column -


i using sql server , wants table rows columns when convert query give me error on keyword

incorrect syntax near '1'. query

select strvalue,1,2 (select  strvalue,nsectionattributeid,  (row_number()  on (partition nsectionattributeid  order nsectionattributeid ) ) colum  tblattributedata  )temp   pivot  (  max(nsectionattributeid)  colum in (1,2)  )piv 

select strvalue,1,2 (select  strvalue,nsectionattributeid,  (row_number()  on (partition nsectionattributeid  order nsectionattributeid ) ) colum  tblattributedata  )temp   pivot  (  max(nsectionattributeid)  colum in ([1],[2])  )piv 

Comments

Popular posts from this blog

Payment information shows nothing in one page checkout page magento -

tcpdump - How to check if server received packet (acknowledged) -