The 'Email Code Here' message is not displayed even though three new rows were added with a priority of High because the IF statement criteria was not satisfied.
The deleted table contains the data in the underlying table referenced in a DELETE before it is actually removed from the database. More specifically, the data referenced in the UPDATE statement is contained in inserted and the data that is being updated is contained in deleted.
You specify the modification action(s) that fire the trigger when it is created.
The following shows how to create a trigger that displays the current system time when a row is inserted into the table to which it is attached.
In order to reduce the time it took to execute the report I decided to use a summary (aka aggregate) table to count the page views as they were entered into the logging table.
Since there were only eight main areas on the site, the summary table contained eight rows and the report ran in less than one second.