Understanding SQL Server PIVOT and UNPIVOT Operators
Version Requirements Before implementing PIVOT or UNPIVOT operations, ensure you're environment meets these prerequisites: The database must be running SQL Server 2005 or later. The database compatibility level must be set to 90 or higher. To check your database version and compatibility level, exec...