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.
| 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. |
 |
|
|
|
|
|
Finding dates within 15 day timespan