Hi,

Thanks for giving reply.I just changed like below.

BEGIN TRAN

DECLARE @DEPTNBR BIGINT

SELECT @DEPTNBR = DEPTNBR

FROM DEPARTMENT_DETAILS WITH (UPDLOCK,READPAST)

WHERE STATUS= 1

UPDATE DEPARTMENT_DETAILS SET STATUS= 0 WHERE DEPTNBR = @DEPTNBR...

Hi,

I need to retrieve the active department uniquely to each user (i.e. departments whose status is 1).After retrieval department number (DEPTNBR) in the select query, i am doing status update...