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/
-- 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