Hi,this is really important to me.When I'm trying to make standart UPDATE via UPDATE TRIGGER like this:

update [table] set [column]=[value] where [index_column]=[index]

it's working,but I've made auto-updating batch which cumulates many updates on one table together,but it won't fire the trigger,it goes like this:

update [table]
 set [column]=case
   when [index_column] in([index]) then [value]
  else [column]
 end

an update essentially works (ofcourse) but trigger is not fire for single-row update neither for multi-row update for example:

update [table]
 set [column]=case
   when [index_column] in([index1]) then [value1]
   when [index_column] in([index2]) then [value2]
  else [column]
 end

I hope you understand,I'll be glad to see your solutions to this,coz whole project is driven thru this core batch-generator and it disables any update-trigger possibilities.

thx

some questions
i am asking why you are using trigger to update, and what types of triggers you are using

Ahmed Ali
Software Developer