USE expenses_db_azure;
PRINT 'RUN SPS 01 - START'
GO
-------------------------------------------------------


--create the tables

EXEC sp_expense_01_create_tables ;
GO

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

--Insert data into table table

EXEC sp_expense_01_insert_raw_data 
@exp_table_into = 'stage01_amex', 
@exp_table_from = 'Amex2015';
GO

EXEC sp_expense_01_insert_raw_data  
@exp_table_into = 'stage01_amex', 
@exp_table_from = 'Amex2016';
GO

EXEC sp_expense_01_insert_raw_data  
@exp_table_into = 'stage01_amex', 
@exp_table_from = 'Amex2017';
GO

EXEC sp_expense_01_insert_raw_data  
@exp_table_into = 'stage01_amex', 
@exp_table_from = 'Amex2018';
GO

EXEC sp_expense_01_insert_raw_data 
@exp_table_into = 'stage01_amex', 
@exp_table_from = 'Amex2019';
GO

EXEC sp_expense_01_insert_raw_data  
@exp_table_into = 'stage01_amex', 
@exp_table_from = 'Amex2020_new';
GO

EXEC sp_expense_01_insert_raw_data  
@exp_table_into = 'stage01_amex', 
@exp_table_from = 'Amex2021_new';
GO

EXEC sp_expense_01_insert_raw_data 
@exp_table_into = 'stage01_amex', 
@exp_table_from = 'Amex2022_new';
GO

EXEC sp_expense_01_insert_raw_data  
@exp_table_into = 'stage01_mast', 
@exp_table_from = 'Mast2016';
GO

EXEC sp_expense_01_insert_raw_data  
@exp_table_into = 'stage01_mast', 
@exp_table_from = 'Mast2017';
GO

EXEC sp_expense_01_insert_raw_data  
@exp_table_into = 'stage01_mast', 
@exp_table_from = 'Mast2018';
GO

EXEC sp_expense_01_insert_raw_data 
@exp_table_into = 'stage01_mast', 
@exp_table_from = 'Mast2019';
GO

EXEC sp_expense_01_insert_raw_data  
@exp_table_into = 'stage01_mast', 
@exp_table_from = 'Mast2020_First5';
GO

EXEC sp_expense_01_insert_raw_data  
@exp_table_into = 'stage01_mast', 
@exp_table_from = 'Mast2021';
GO

EXEC sp_expense_01_insert_raw_data 
@exp_table_into = 'stage01_mast', 
@exp_table_from = 'Mast2022';
GO

EXEC sp_expense_01_insert_raw_data_2 
@exp_table_into = 'stage01_lloyds', 
@exp_table_from = 'Lloyds2016';
GO

EXEC sp_expense_01_insert_raw_data_2 
@exp_table_into = 'stage01_lloyds', 
@exp_table_from = 'Lloyds2017';
GO

EXEC sp_expense_01_insert_raw_data_2 
@exp_table_into = 'stage01_lloyds', 
@exp_table_from = 'Lloyds2018';
GO

EXEC sp_expense_01_insert_raw_data_2 
@exp_table_into = 'stage01_lloyds', 
@exp_table_from = 'Lloyds2019';
GO

EXEC sp_expense_01_insert_raw_data_2 
@exp_table_into = 'stage01_lloyds', 
@exp_table_from = 'Lloyds2020';
GO

EXEC sp_expense_01_insert_raw_data_2 
@exp_table_into = 'stage01_lloyds', 
@exp_table_from = 'Lloyds2021';
GO

EXEC sp_expense_01_insert_raw_data_2 
@exp_table_into = 'stage01_lloyds', 
@exp_table_from = 'lloyds2022';
GO

PRINT 'START'
EXEC sp_expense_02_clean_amex;
PRINT 'END'
GO

PRINT 'START'
EXEC sp_expense_02_clean_mast;
PRINT 'END'

PRINT 'START'
EXEC sp_expense_02_clean_lloyds;
PRINT 'END'

PRINT 'START COMBINE'
EXEC sp_expense_03_combine_tables;
PRINT 'END COMBINE'

--PRINT 'START CATEGORISE'
--EXEC sp_expense_03_categorise_tables;
--PRINT 'END CATEGORISE'