This sp does not work. It never returns 1 always 0.

1. Create global temp. table:

Select ip, Count(tbl_timetracker.ip) As Total

into ##result

from tbl_timetracker

where datediff(day,getdate(),date)=0 and date <= getdate()

Group BY term,IP

Having COUNT(ip) > 20

2. Evaluate result table ##result based on your requirements

3....

The most straightforward way would be to create a global temp table based on your query, then evaluate your result and send email only if it is true