I don't have much knowledge in PIVOT in SQL Server.
I tried the cross tab query using PIVOT.
The below error raised, What I have to do for this? Msg 325, level 15, State 1, Line 2
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 stored procedure sp_dbcmptlevel.
In sp_dbcmptlevel, They specified some compatibility levels 60,65,70,80 or 90.
Where I can find Compatibility levels in DataBase?
Thanks and Regards