Peso (4/17/2008)

UPDATETable1

SETrecordtime = case when DATEDIFF(second, recordtime, @rtime) > 0 then @rtime else recordtime end,

foo = case when @Foo <> foo then @Foo else foo end,

bar...

That's an interestings solution. May I ask how you calculate your hash? That is, what algorithms do you use, and how do you do it?

Thanks. I am aware of how to write the trigger, that's not my problem. As I said, I cannot change the existing trigger, so i'm looking for a...

Thanks for your response, but perhaps i wasn't clear enough. My problem is not the cost of updating a column to the same value, but rather that the trigger...