Re Trigger Related Problem...?

Question

Re Trigger Related Problem...?

SQL-290976

SSC Enthusiast

Points: 189
More actions
January 4, 2006 at 11:56 pm

#167569

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

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

V.Kadal Amutham Old Hand Points: 363 More actions · Answer 1

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

vkadal@gmail.com

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 2

Cross-posted thread. Best answer is on this page :

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=145&messageid=248311

Consider this thread closed.