SQL Statement Error in Commissions Screen/Duplicate key

Created by Hamta Fakhravar, Modified on Mon, 30 Oct, 2023 at 5:09 PM by Hamta Fakhravar

begin transaction
UPDATE t
SET nxtavailablenum = '51896'
--select *
FROM dbo.trfnxtnum t
WHERE trxtype = 'CRREC'
AND client = 'CA'
----Commit transaction

-- the current number befor update>> 51594
--select max(seqnum) from tcrcomm =>> 51895