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]))