quote:

---

Originally posted by dyckwal

Hello,

I have a trigger which does an update of a table and it seems
not able to handle more then one record...

What I wanted to do is whenever there is an update on the table INFO_SSCC, then take a look at the value of LOCKED_NR and SSCC_STATUS.
Depending on the value, do something.
If the Status is > 0 insert some values into the table INFO_LOCKED_OUT.
The two other cases is to remove the record data from the table INFO_LOCKED_OUT.

Probebly should use some joins, but I don't know where and how...

So can someone give me a tip...

Here the code :

IF UPDATE(LOCKED_NR) OR UPDATE (SSCC_STATUS)
BEGIN
IF (SELECT LOCKED_NR FROM INSERTED) > 0
BEGIN
INSERT INTO INFO_LOCKED_OUT(SSCC, LOCKED_NR)
SELECT INS.SSCC, INS.LOCKED_NR
FROM INSERTED INS
END

IF (SELECT LOCKED_NR FROM INSERTED) = 0
BEGIN
DELETE FROM INFO_LOCKED_OUT
WHERE SSCC = (SELECT SSCC FROM INSERTED)
AND LOCKED_NR = (SELECT LOCKED_NR FROM DELETED)
END Are you sure of that your select from inserted will get only value if its getting more then one value then i guess u should use in clause.

IF (SELECT SSCC_STATUS FROM INSERTED) = 9-- Are you sure this 9 or 0 Check out this.
BEGIN
DELETE FROM INFO_LOCKED_OUT
WHERE SSCC = (SELECT SSCC FROM INSERTED)
END
END

---