DỰ ÁN PHẦN MỀM QUẢN LÝ TÀI SẢN NGÂN HÀNG BẢN VIỆT

DECLARE @REQ_ID VARCHAR(15), @DATE DATETIME

SET @REQ_ID=(SELECT REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2021/001620')

UPDATE TR_REQUEST_DOC_DT SET UNIT_NAME = N'Cái' WHERE REQ_DOC_ID =@REQ_ID

UPDATE CM_DVDM SET DVDM_NAME =(SELECT DEP_NAME FROM CM_DEPARTMENT WHERE DEP_CODE ='0690602' AND BRANCH_ID ='DV0001')

WHERE DVDM_CODE ='0690602'

UPDATE CM_DVDM SET DVDM_NAME =(SELECT DEP_NAME FROM CM_DEPARTMENT WHERE DEP_CODE ='0690603' AND BRANCH_ID ='DV0001')

WHERE DVDM_CODE ='0690603'

UPDATE CM_DVDM SET DVDM_NAME =(SELECT DEP_NAME FROM CM_DEPARTMENT WHERE DEP_CODE ='0690604' AND BRANCH_ID ='DV0001')

WHERE DVDM_CODE ='0690604'

UPDATE CM_DVDM SET DVDM_NAME =(SELECT DEP_NAME FROM CM_DEPARTMENT WHERE DEP_CODE ='0690405' AND BRANCH_ID ='DV0001')

WHERE DVDM_CODE ='0690405'

UPDATE CM_DVDM SET DVDM_NAME =(SELECT DEP_NAME FROM CM_DEPARTMENT WHERE DEP_CODE ='0690703' AND BRANCH_ID ='DV0001')

WHERE DVDM_CODE ='0690703'

UPDATE CM_DVDM SET DVDM_NAME =(SELECT DEP_NAME FROM CM_DEPARTMENT WHERE DEP_CODE ='0690802' AND BRANCH_ID ='DV0001')

WHERE DVDM_CODE ='0690802'

UPDATE CM_DVDM SET DVDM_NAME =(SELECT DEP_NAME FROM CM_DEPARTMENT WHERE DEP_CODE ='0692103' AND BRANCH_ID ='DV0001')

WHERE DVDM_CODE ='0692103'

UPDATE CM_DVDM SET DVDM_NAME =(SELECT DEP_NAME FROM CM_DEPARTMENT WHERE DEP_CODE ='0692104' AND BRANCH_ID ='DV0001')

WHERE DVDM_CODE ='0692104'

UPDATE CM_DVDM SET DVDM_NAME =(SELECT DEP_NAME FROM CM_DEPARTMENT WHERE DEP_CODE ='8990000' AND BRANCH_ID ='DV0001')

WHERE DVDM_CODE ='8990000'

UPDATE CM_DVDM SET DVDM_NAME =(SELECT DEP_NAME FROM CM_DEPARTMENT WHERE DEP_CODE ='069040304' AND BRANCH_ID ='DV0001')

WHERE DVDM_CODE ='069040304'

UPDATE CM_DVDM SET DVDM_NAME =(SELECT DEP_NAME FROM CM_DEPARTMENT WHERE DEP_CODE ='069040306' AND BRANCH_ID ='DV0001')

WHERE DVDM_CODE ='069040306'

UPDATE CM_DVDM SET DVDM_NAME =(SELECT DEP_NAME FROM CM_DEPARTMENT WHERE DEP_CODE ='0690404' AND BRANCH_ID ='DV0001')

WHERE DVDM_CODE ='0690404'

UPDATE CM_DVDM SET DVDM_NAME =(SELECT DEP_NAME FROM CM_DEPARTMENT WHERE DEP_CODE ='0690601' AND BRANCH_ID ='DV0001')

WHERE DVDM_CODE ='0690601'

UPDATE CM_DVDM SET DVDM_NAME =(SELECT DEP_NAME FROM CM_DEPARTMENT WHERE DEP_CODE ='0690803' AND BRANCH_ID ='DV0001')

WHERE DVDM_CODE ='0690803'

UPDATE CM_DVDM SET DVDM_NAME =(SELECT DEP_NAME FROM CM_DEPARTMENT WHERE DEP_CODE ='0690902' AND BRANCH_ID ='DV0001')

WHERE DVDM_CODE ='0690902'

UPDATE CM_DVDM SET DVDM_NAME =(SELECT DEP_NAME FROM CM_DEPARTMENT WHERE DEP_CODE ='0690903' AND BRANCH_ID ='DV0001')

WHERE DVDM_CODE ='0690903'

UPDATE CM_DVDM SET DVDM_NAME =(SELECT DEP_NAME FROM CM_DEPARTMENT WHERE DEP_CODE ='0690905' AND BRANCH_ID ='DV0001')

WHERE DVDM_CODE ='0690905'

UPDATE CM_DVDM SET DVDM_NAME =(SELECT DEP_NAME FROM CM_DEPARTMENT WHERE DEP_CODE ='0690907' AND BRANCH_ID ='DV0001')

WHERE DVDM_CODE ='0690907'

UPDATE CM_DVDM SET DVDM_NAME =(SELECT DEP_NAME FROM CM_DEPARTMENT WHERE DEP_CODE ='0691004' AND BRANCH_ID ='DV0001')

WHERE DVDM_CODE ='0691004'

UPDATE CM_DVDM SET DVDM_NAME =(SELECT DEP_NAME FROM CM_DEPARTMENT WHERE DEP_CODE ='0691005' AND BRANCH_ID ='DV0001')

WHERE DVDM_CODE ='0691005'

UPDATE CM_DVDM SET DVDM_NAME =(SELECT DEP_NAME FROM CM_DEPARTMENT WHERE DEP_CODE ='0691006' AND BRANCH_ID ='DV0001')

WHERE DVDM_CODE ='0691006'

UPDATE CM_DVDM SET DVDM_NAME =(SELECT DEP_NAME FROM CM_DEPARTMENT WHERE DEP_CODE ='0692001' AND BRANCH_ID ='DV0001')

WHERE DVDM_CODE ='0692001'

UPDATE CM_DVDM SET DVDM_NAME =(SELECT DEP_NAME FROM CM_DEPARTMENT WHERE DEP_CODE ='0692002' AND BRANCH_ID ='DV0001')

WHERE DVDM_CODE ='0692002'

UPDATE CM_DVDM SET DVDM_NAME =(SELECT DEP_NAME FROM CM_DEPARTMENT WHERE DEP_CODE ='0692003' AND BRANCH_ID ='DV0001')

WHERE DVDM_CODE ='0692003'

UPDATE CM_DVDM SET DVDM_NAME =(SELECT DEP_NAME FROM CM_DEPARTMENT WHERE DEP_CODE ='0692101' AND BRANCH_ID ='DV0001')

WHERE DVDM_CODE ='0692101'

UPDATE CM_DVDM SET DVDM_NAME =(SELECT DEP_NAME FROM CM_DEPARTMENT WHERE DEP_CODE ='0692102' AND BRANCH_ID ='DV0001')

WHERE DVDM_CODE ='0692102'

UPDATE CM_DVDM SET DVDM_NAME =(SELECT DEP_NAME FROM CM_DEPARTMENT WHERE DEP_CODE ='0692105' AND BRANCH_ID ='DV0001')

WHERE DVDM_CODE ='0692105'

UPDATE CM_DVDM SET DVDM_NAME =(SELECT DEP_NAME FROM CM_DEPARTMENT WHERE DEP_CODE ='0692201' AND BRANCH_ID ='DV0001')

WHERE DVDM_CODE ='0692201'

UPDATE CM_DVDM SET DVDM_NAME =(SELECT DEP_NAME FROM CM_DEPARTMENT WHERE DEP_CODE ='0692203' AND BRANCH_ID ='DV0001')

WHERE DVDM_CODE ='0692203'

UPDATE CM_DVDM SET DVDM_NAME =(SELECT DEP_NAME FROM CM_DEPARTMENT WHERE DEP_CODE ='0692205' AND BRANCH_ID ='DV0001')

WHERE DVDM_CODE ='0692205'

UPDATE CM_DVDM SET DVDM_NAME =(SELECT DEP_NAME FROM CM_DEPARTMENT WHERE DEP_CODE ='89900001' AND BRANCH_ID ='DV0001')

WHERE DVDM_CODE ='89900001'