Batch Updates And Triggers

Hello All

I am running a statment that updates 248 records in a table. That table has a trigger on update.

The First thing that the trigger does is to declare a number of variables and then set them using the values from the inserted and deleted temp tables.

This works fine when you are updating one row at a time but when you run a batch update it errors.

I believe this is because i am assuming that in a batch update a single row will be updated and then the trigger fired, then the next row and so on.

I now know that this is not the case. Is there a way of linking the 3 variables (see Below) so they all return information form a single row.

Declare@ApplicantId Int,
@NewStatus Int,
@OldStatus Int

Set @ApplicantId = (Select ApplicantID from Inserted)
Set @NewStatus = (Select StatusID from Inserted)
Set @OldStatus = (Select StatusID from Deleted)

Hope that makes sense

Thanks for any help.

Steve