This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(9.6, 4%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMV%3C/text%3E%3C/svg%3E)
Hello
I created a trigger that only works if I update only one record at a time. If I perform a multiple update, only the first record updates me. Any ideas?
Thanks in advance
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(278.4, 12%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJL%3C/text%3E%3C/svg%3E)
You need to provide your sample table and data for your question. It is hard to to provide suggestion from posting.
sorry you're right. When I update the table mov_carico should I update the table anag_silos with some data
with update mov_carico set quantita=quantita*1 where id_movmag=121
works with no problems, but not works with
update mov_carico set quantita=quantita*1
this is the trigger
CREATE TRIGGER I40_Silos on [mov_carico] AFTER INSERT , UPDATE ,DELETE
AS DECLARE @ID INT ;
IF EXISTS (SELECT 0 FROM inserted)
BEGIN
IF EXISTS (SELECT 0 FROM deleted)
SELECT @ID = ins.id_movmag FROM INSERTED ins;
UPDATE GS set
GS.quantita=C1.quantita
,GS.Prodotto=a1.cod_magazzino
,GS.Data_reg=c1.data_reg
,GS.lotto=c1.varie_uno
FROM Geco_silos GS
inner join mov_carico c1 on c1.id_movmag=@ID
inner join tab_cmaga d1 on d1.id_doc=c1.id_doc
inner join anag_magazzino a1 on a1.id_magazzino=c1.id_magazzino
where isnull(d1.flgI40_Silos,0)+isnull(a1.flgi40_silos,0)=2
and gs.id_movmag=@id;
IF @@ROWCOUNT=0
INSERT INTO Geco_silos (Data_reg,Prodotto,Num_silos,Quantita,Lotto,ID_Movmag)
SELECT c1.data_reg,a1.cod_magazzino [prodotto],1 [num_silos],c1.quantita,c1.varie_uno [lotto],c1.id_movmag
from mov_carico c1
inner join tab_cmaga d1 on d1.id_doc=c1.id_doc
inner join anag_magazzino a1 on a1.id_magazzino=c1.id_magazzino
where isnull(d1.flgI40_Silos,0)+isnull(a1.flgi40_silos,0)=2
AND c1.id_movmag=@ID
END ELSE
BEGIN
SELECT @ID = del.id_movmag FROM DELETED del;
DELETE FROM Geco_silos where ID_Movmag=@ID
END
Thanks for posting your code.
Inside the trigger, you are using a variable that caused your problem.
You need to use to use the virtual tables(deleted/inserted) to work with your code.
Hi @Massimo Valtolina
Did you have a chance to try the proposed solution?
If all of the answers are not working or helpful, please share with us your confusion or more details about this issue.
I created a trigger that only works if I update only one record at a time.
Then your trigger code is wrong.
You have to use the virtual table "inserted" and "deleted", which contains all 1-n effected records, see
I didn't have the chance to try, I changed my strategy