Fwd: TSQL To Postgres - Unpivot/Union All

---------- Forwarded message ---------
From: Anthony Apollis <anthony.apollis@gmail.com>
Date: Thu, 20 Jul 2023 at 16:07
Subject: Re: TSQL To Postgres - Unpivot/Union All
To: Geoff Winkless <pgsqladmin@geoff.dj>, David G. Johnston <
david.g.johnston@gmail.com>


I am attaching my TSQL and Postgres SQL:

On Thu, 20 Jul 2023 at 15:58, Geoff Winkless <pgsqladmin@geoff.dj> wrote:

> On Thu, 20 Jul 2023 at 13:17, Anthony Apollis <anthony.apollis@gmail.com>
> wrote:
>
>> The Postgres i used: INSERT INTO temp_FieldFlowsFact
>> SELECT "Account", "Calendar day", "Financial year", "Period",
>>
>> [snip]
>
> At the very least, include a column list in your INSERT statement. We have
> no way of checking where any of your results are going.
>
> Geoff
>