January 4, 2006 at 11:56 pm
I have a table User_Master. I implemented a After trigger For Update on this table. When i update suppose 50 records then trigger fires 50 times but my requirement is that on updation of 50 records trigger should be fire once only.
Please Answer Brief
January 9, 2006 at 8:00 am
This was removed by the editor as SPAM
January 11, 2006 at 10:27 pm
Add a coulumn in the table to keep track of the record numbers. Check for the record number has reached 50. Then do the rest of the operation upon raching the 50th record
V. Kadal Amutham
December 4, 2006 at 7:46 am
Cross-posted thread. Best answer is on this page :
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=145&messageid=248311
Consider this thread closed.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply