I have two variables StartTimeStmp and EndTimeStmp, i am going to assign the Start timestamp to it based on Last Successful Job Runtime and EndTimeStamp would be current time of system.
SET StartTimeStmp = '2022-03-24 15:40:00.000';
SET EndTimeStmp = '2022-03-24 20:00:00.000';
I need to pass these two variables to Query String defined in a cell. How to pass these Values. The following is not a complete Query. Just snippet of query.
qrystr=('''
SELECT *
FROM (
SELECT
CI.CORPORATE_ITEM_INTEGRATION_ID , CI.CORPORATE_ITEM_CD where CI.DW_CREATE_TS < '2022-02-23 20:00:00.000' ) ''')