SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help
An online community of DBAs, developers and data intelligence builders, with videos, articles, resources and online events for members and non-members.
Find out more >>
(Eli Leiba) The PIVOT operator (or “cross-tab” operation) is a very handy tool in SQL Server, but its main limitation is that you often don’t know the values that you need to pivot on.