June 25, 2012 at 11:38 am
I have a table A which has an insert,update and delete trigger which inserts updates and deletes values in a table B when ever A is inserted updated and deleted.
Both are joined with an ID common to both table.
No other proc updates table B,it gets updated,inserted when any activity is done on A.
For a particular Id the sum of values of a particular column in table A dont match the sum of values for the same column in Table B.
Is it that the triggers are not working properly?
We have this system in place for many years but this problem rose up recently starting this fiscal year.
Please help.If required I can post the code for the triggers.
Thanks,
June 25, 2012 at 11:50 am
I'd need to see the code for the triggers and the create scripts for the tables, before I could offer any help on this.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply