Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Finding dates within 15 day timespan

Author  Topic 

caoneill
Starting Member

10 Posts

Posted - 2014-09-07 : 14:42:44
Hi all,

I have a table that contains activity dates. If a certain activity occurs 3 times within fifteen days, I need to flag them that account.
What is the best approach?

thanks!

SharkAl
Starting Member

8 Posts

Posted - 2014-09-07 : 17:49:26
A trigger that then calls a procedure to send you an email that this has happened (assuming you want an email).

The trigger is activated when the occurance <= 3 between sysdate -15.

Go to Top of Page
   

- Advertisement -