Problem statement is to make user balance update for concurrent users. as many(even one user can send several request) can hit db, so I used updlock,rowslock to make transaction atomic. but such hints cause locking that leads to deallock. so how can I improve my code to suppress locks ...