Pivot/Unpivot. My only use for these are when I answer Stackoverflow questions, so I can never remember how to do it correctly.
Since moving to Postgres I've been using the crosstab function to do pivoting. Have you given it a try?
In my workplace we're using SQL Server, I'm not familiar with Postgres nor am I aware of crosstab function, so the answer is no, but I will check it out...
If you're a Microsoft shop then MS Access has a "crosstab" query (and has done since v1.0 if memory serves).
Are you sure you want to hide this comment? It will become hidden in your post, but will still be visible via the comment's permalink.
Hide child comments as well
Confirm
For further actions, you may consider blocking this person and/or reporting abuse
We're a place where coders share, stay up-to-date and grow their careers.
Pivot/Unpivot. My only use for these are when I answer Stackoverflow questions, so I can never remember how to do it correctly.
Since moving to Postgres I've been using the crosstab function to do pivoting. Have you given it a try?
In my workplace we're using SQL Server, I'm not familiar with Postgres nor am I aware of crosstab function, so the answer is no, but I will check it out...
If you're a Microsoft shop then MS Access has a "crosstab" query (and has done since v1.0 if memory serves).