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 |
|
shef99
Starting Member
1 Post |
 Posted - 2010-08-10 : 17:36:20
|
| Hello Everyone,I'm very new to SQL Server and I have a question regarding triggers and or reporting services. I work for a call center and I would like to know if a certain account is calling more frequently than normal, so that I can notify the parent company, sales rep, etc. Is there anyway to do this with a trigger or SSRS? I can't think of a way to write a trigger based on frequency. |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2010-08-11 : 03:14:54
|
| You haven't really provided enough information to give a good answer here...but I'm pretty sure a trigger isn't the method you're looking for. Do you keep records of every call made?- LumbagoMy blog (yes, I have a blog now! just not that much content yet) -> www.thefirstsql.com |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-08-11 : 10:27:52
|
| Sounds like you just need a table capturing call details and then you need to group on accountid and take count of calls and select one with maximum count. so its just grouping that you want to do------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
Trigger based on insert frequency