Create insertSubInfo.sql

/* Please go over the README.txt file for complete installation instructions */

This SQL script will create the Stored Procedure called by our sublogger code. The stored procedure will add data to two tables: tbl_subsMain and tbl_subsDetails.

For tbl_subsMain, a check will be performed to see if the subscriptions already exist - if new subscriptions have been added to our base XML file, they will be logged to this table, and their relevant data will be added to the tbl_subsDetails.  This stored procedure will run every time it is triggered by the sublogger code, based on job frequency