--Combine the individually cleaned card tables

--then make a copy of this combined table to be used for
--categorising the transactions

USE expenses_db_azure;
GO


---------------------------------------------------------------


DROP PROCEDURE IF EXISTS sp_expense_03_combine_tables;
GO

CREATE PROCEDURE sp_expense_03_combine_tables 

AS

PRINT 'START COMBINE AMEX'

INSERT INTO stage02_master01_combine 
SELECT * FROM stage02_amex_clean;

--GO

PRINT 'START COMBINE MAST'
INSERT INTO stage02_master01_combine 
SELECT * FROM stage02_mast_clean;

--GO

------------------------------------------
PRINT 'START COPY CATEGORY'
INSERT INTO stage02_master02_category 
SELECT * FROM stage02_master01_combine;


PRINT 'END COMBINE'

GO