The dangerous beauty of the PIVOT operator in SQL Server

In today’s blog posting I want to discuss one specific T-SQL language construct in SQL Server – the PIVOT operator that was introduced back with SQL Server 2005. I always refer to this language construct as one of the most dangerous ones in SQL Server – and you will very soon see why. Before we …

The dangerous beauty of the PIVOT operator in SQL Server + read more