How would you do dynamic pivot SQL in Amazon Redshift? (This elegant script might be used in many other databases as well)
Several days ago I have spent a few hours of my life figuring out how to do dynamic pivot in Amazon Redshift. To tell you the truth, I have expected much more from this DBMS SQL language. Redshift is based on Postgre SQL 8.0.2 ( which was…