Getting frustrated with my lack of SQL-foo ...<BR><BR>I want to update my 'main' table based on the query of an 'editor' table (a copy of the 'main' table with the additional field named delta which ...

Wondering if anyone can help out with a deadlock problem we are experiencing. Our set up is SQL Server 7 (no SP) running on NT4 (SP6a) -- we cannot update this any time soon. When we run multiple ...