we're working with sql 2008 and 8.8 pl 15.
we get an error when trying to run a query with a pivot function.
"1). [Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near 'PIVOT'. You may need to set the compatibility level of the current database to a higher value to enable this feature. See help for the SET COMPATIBILITY_LEVEL option of ALTER DA 2). [Microsoft][SQL Server Native Client 10.0][SQL Server]Statement (OCTR) (s) could not be prepared."
what can i do to resolve this?