Sometime back I was asked the best way for processing records row by row. Cursor was the only solution that I was thinking till now.

But, the idea totally changed when I read an article today on row by row processing with triggers.

Here is the link. Read on …

http://www.sqlservercentral.com/columnists/asobati/2747.asp