Davide Mauri Blog

Experiences with SQL Server

PIVOT syntax error

After a long period full of work i've been able to play again with SQL 2005.

I was trying to apply PIVOTing to a real database that i ported to SQL 2005 ad i found the the query i wrote using the PIVOT operator gave me a "syntax error". The strange thing is that it was really not a concern of syntax, but was the database that was not in 90 compatibilty mode.

So, do not bang you head again an unbreakable wall as i did trying to find that syntax error, but check the database options!