Posts
49
Comments
50
Trackbacks
26
November 2004 Blog Posts
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!

posted @ Tuesday, November 30, 2004 7:22 AM | Feedback (0)
News