On 2023-Sep-19, Anthony Apollis wrote:
> I have inherited this code, problem is it is over code, i believe. The
> package is gonna run once a month and this code run is a loop. How can this
> loop be running and checking data up until last day, if it only run once a
> month?
I didn't stop to
On 9/19/23 10:09, Anthony Apollis wrote:
I have a table that needs to give me all data up until yesterday. This
All data since, beginning of month, beginning of year, beginning of time?
will be part of an SSIS package that runs monthly, a day before the last
day. code is:
You need to
I have a table that needs to give me all data up until yesterday. This will
be part of an SSIS package that runs monthly, a day before the last day.
code is:
-- Create the new table if it doesn't exist and insert data
CREATE TABLE IF NOT EXISTS "model"."IMETA_ZTBR_BRACS_Model_TA_BW" AS
SELECT