Trying to run an update on table. I get the following
Transaction (Process ID 94) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
Query looks like this.. any ideas?
field3 = Src.Item
FROM Reps Src, dbo.ae_dt2 Tgt
Src.RepNo = Tgt.field3