March 19, 2003 at 7:28 am
I am trying to pull a report of before and after changes (basically a picture) for a certain department. I have done this, but now the user only wants relevant changes. There are triggers on all of the necessary tables which if anything on the table changes it sends me the personguid because something in that records has changed even though what changed may not be a relevent field in the report, but, without using a cursor to compare each field for each row in the table(which we would all agree would eat up processor time), does anyone have any other ideas?
Thanks for your time.
March 19, 2003 at 9:57 am
I think that for update triggers is easy but for the others you will have to use a cursor.
Unless the transacction is a massive transacction, (10000 inserts for expample), the cursor won't be so big, you have to use it against deleted and inserted tables.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply