I have a colleague who has a stroke of genius. He can create things in SQL and PL/SQL that I find very hard to fathom, let alone could have come up with myself. His name is Anton and his recent focus has been Pivoting in SQL. The process of turning a Query Result upside down to present it differently. Turning the set of values in one of the columns into the column headings for the entire query. Like taking the following query result: and turning it into this structure: Anton recently wrote a brief, somewhat cryptic article on Pivoting SQL … Continue reading Dynamic SQL Pivoting – Stealing Anton’s Thunder