bing siu

bing siu

  • NA
  • 3
  • 0

error pivot query

Jun 14 2008 12:25 AM

I would like to know if this can be done in sql server 2005 express edition.
It is a pivot query and i keep on getting this error: incorect syntax near '('
it would look like a parentesis error, but i can,t see it. Please help, Thanks!This is the code:
SELECT     room[12], [3], [18], [11], [16], [15]
FROM         (SELECT     datein, resv, room
                       FROM          Table1) PIVOT (max(resv) FOR room IN ([12], [3], [18], [11], [16], [15]))

 


Answers (2)