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