Have written an SP that does what I need, thanks to people for suggesting cursors. Antares, I don't know why your trigger didn't work on my table as it all...

OK, still no luck but am looking into looping through each record using cursors.

Antares686 et al who suggested the same, I have tried joining to the inserted table but to...

Here's the original trigger, MobID and ServNum make up a composite primary key.

CREATE TRIGGER [RecStat] ON dbo.tblMobilisationTransaction

FOR INSERT

AS

DECLARE @MobID as varchar (7)

DECLARE @ServNum as char (9)

SELECT @MobID =(SELECT...

Thanks for that fella, still no joy though. The engine just doesn't seem to like it when it has to run an update query that affects more than one record...

Already checked that, inserted those values into a table and it only returned one record.

If I specify just one record for the update query it works, however as soon...