Re: How to store query result into another table using stored procedure

2023-06-09 Thread Erik Wienhold
> On 09/06/2023 07:51 CEST Rama Krishnan wrote: > > CREATE or REPLACE PROCEDURE deleted_cards_count_test(start_date TIMESTAMP, > end_date TIMESTAMP) AS $$ > DECLARE > current_date TIMESTAMP; > month_start_date TIMESTAMP; > month_end_date TIMESTAMP; > month24_end_date TIMESTAMP; > no_deleted_cards

Re: How to store query result into another table using stored procedure

2023-06-09 Thread Ron
On 6/9/23 00:51, Rama Krishnan wrote: Hi All, I have a table like below Create table if not exists digi_card(      Digi_card_id varchar(100),     created_date timestamp,     updated_date timestamp,      status varchar(50),      reason varchar(50) ); Sample values: Insert into digi_card value

How to store query result into another table using stored procedure

2023-06-09 Thread Rama Krishnan
Hi All, I have a table like below Create table if not exists digi_card( Digi_card_id varchar(100), created_date timestamp, updated_date timestamp, status varchar(50), reason varchar(50) ); Sample values: Insert into digi_card values ('ee4422', '2019-03-01 00:25:00', '202