InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 23:58:10 GMT20http://www.sqlservercentral.com/Forums/Topic531303-324-1.aspxDear friend it worked exactly as i want ,and by the way thanks to your explanation i think i got the logic thank you very very much, it was a lifesaver answer for me ;)Thu, 10 Jul 2008 14:26:03 GMTdelta dirachttp://www.sqlservercentral.com/Forums/Topic531303-324-1.aspxTriggers fire once per insert/update/delete, not once per row. Your line here[code]select @stokkod=stokkod,@quantity=quantity from deleted[/code]Will fetch only one of the values from the deleted table, while there are as many as rows that you delete.Maybe something more like this... (rough, untested)[code]UPDATE stokSET stokquantity =stokquantity-deleted.quantity FROM stok inner join deleted onstok.stokkod = deleted.stokkod[/code]Thu, 10 Jul 2008 00:19:04 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic531303-324-1.aspxHi everyonei 'm using sql server express 2005 and i have tree triggers for insert delete and updateİ am making my inserts ,deletes or updates through ADO.NET (so multiple rows in an update or delete or insert)i have a sales table and a sales details table and i am making a plus operation on stock when it's an insert and the opposite for deletes(putting back the stocks quantity),The insert works fine (when i make an insert all the godds that sold are on the plus values and taht's right), the update is also fine but when it comes to delete ,it updates only the fist stocks that sold and the other rows are untouchedhere's my delete triggerALTER TRIGGER [dbo].[faturagdelete] on [dbo].[fatura]for deleteAS declare @stokkod int,@quantity decimal(8,2)select @stokkod=stokkod,@quantity=quantity from deletedUPDATE stokSET stokquantity =stokquantity-@quantity FROM stok WHERE stok.stokkod =@stokkodwhy did this trigger updated only the First items quantity and leave the rest(the same methot is working on insert trigger bu this ones not)i'll be very appreciate for any ideas thanks.Wed, 09 Jul 2008 18:04:23 GMTdelta dirac