Creating a trigger to Insert in to Another table based on SUMMATION value in another table in SQL Server
<p>I am trying to write a Trigger to Update a column(Columns Name:Sponsor Tier) in table(Table Name: Sponsor) when I Insert the data in to another table(Table: Sponsored). </p>

<p>If the SUM of Sponsorship Amount in > 5000 , I want to set the Sponsor tier to 'Platinum'<br>
 If Sponsorship Amount &lt;=5000 and >500 , I want to set Sponsor Tier to "GOld".</p>

<p>How would I do this?</p>