Re: Fwd: TSQL To Postgres - Unpivot/Union All

2023-07-20 Thread Thomas Kellerer
Anthony Apollis schrieb am 20.07.2023 um 14:17: Does not give me outputs for columns: Metric and Pricing Channel: image.png What am i doing wrong? Please assist? UNPIVOT can be done using a LATERAL sub-query with a VALUES clause: https://blog.sql-workbench.eu/post/unpivot-with-postgres/

Fwd: TSQL To Postgres - Unpivot/Union All

2023-07-20 Thread Anthony Apollis
-- Forwarded message - From: Anthony Apollis Date: Thu, 20 Jul 2023 at 16:07 Subject: Re: TSQL To Postgres - Unpivot/Union All To: Geoff Winkless , David G. Johnston < david.g.johns...@gmail.com> I am attaching my TSQL and Postgres SQL: On Thu, 20 Jul 2023 at 15:58, Geoff Winkle