USE expenses_db_azure;
GO
PRINT 'CREATE SPS 01 START'

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



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

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

---------------------------------------------------------------
-- Create an sp that inserts raw data into AMEX, MAST

DROP PROCEDURE IF EXISTS sp_expense_01_insert_raw_data
GO

CREATE PROCEDURE sp_expense_01_insert_raw_data 
@exp_table_into nvarchar(20), 
@exp_table_from nvarchar(20)

AS
--
DECLARE @sqlstr AS NVARCHAR(200)

SET @sqlstr = 'INSERT INTO ' + @exp_table_into + ' (exp_date, exp_desc, exp_amount) '

SET @sqlstr = @sqlstr + 'SELECT Date, Description, Amount ' 

SET @sqlstr = @sqlstr + ' FROM ' + @exp_table_from

PRINT 'SP EXPENSE INSERT DATA - START: ' + @exp_table_from
PRINT @sqlstr
EXEC sp_executesql @sqlstr
PRINT 'SP EXPENSE INSERT DATA - DONE'
GO

-------------------------------------------------------
---------------------------------------------------------------
-- Create an sp that inserts raw data into LLOYDS

DROP PROCEDURE IF EXISTS sp_expense_01_insert_raw_data_2
GO

CREATE PROCEDURE sp_expense_01_insert_raw_data_2 
@exp_table_into nvarchar(20), 
@exp_table_from nvarchar(20)

AS
--
DECLARE @sqlstr AS NVARCHAR(200)

SET @sqlstr = 'INSERT INTO ' + @exp_table_into + ' (exp_date, exp_desc, exp_amount) '

SET @sqlstr = @sqlstr + 'SELECT Transaction_Date, Transaction_Description, Debit_Amount ' 

SET @sqlstr = @sqlstr + ' FROM ' + @exp_table_from

PRINT 'SP EXPENSE INSERT DATA - START: ' + @exp_table_from
PRINT @sqlstr
EXEC sp_executesql @sqlstr
PRINT 'SP EXPENSE INSERT DATA - DONE'
GO

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