Hi

Please see the update statements Update 1 and Update 2 below. The table "dataViewReques ts" mentioned in the query is a high transactional table where people might be doing an insert, update 1 or update 2 (see queries below). All these statements are in three different SPs. Sometimes when we run Update 1 there has been the error "Transactio n (Process ID 156) was deadlocked on lock resources with another process and...