title: Update mapping table with new data and add alert
body: <p>I have data in a staging table that needs to be processed to my final transformed table.</p>
  <p>My process is as follows:</p>
  <ol>
  <li>Load data into staging table (using Azure Data Factory)</li>
  <li>Stored Proc to process data to the transformed table</li>
  </ol>
  <p>What is important in step 2 is that I have a mapping table which is used to compare with data in my staging table.</p>
  <p>The mapping table has to be up-to-date. If a new country is identified in the staging table, and that country is not in the mapping table, the mapping table should be updated with the new country.</p>
  <p>For example:</p>
  <p>Table 1 = staging table</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Country</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>USA</td>
  </tr>
  <tr>
  <td>Brazil</td>
  </tr>
  <tr>
  <td>Chile</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>Table 2 = mapping table</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>ID</th>
  <th>Country</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>1</td>
  <td>USA</td>
  </tr>
  <tr>
  <td>2</td>
  <td>Brazil</td>
  </tr>
  <tr>
  <td>3</td>
  <td>Canada</td>
  </tr>
  <tr>
  <td>4</td>
  <td>Peru</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>In table 1, the country Chile is a new country in the staging table. Therefore, this country should be added to the mapping table.</p>
  <p>Also, when the mapping table is updated with the new country, a notification should be sent to the relevant business unit that a new country has been added to the mapping table.</p>
  <p>I am still new to SQL, and would really appreciate any help.</p>