Project

General

Profile

Bug #1515

Vận Hành VB GOLIVE 26/04/2023

Added by Luc Tran Van about 2 years ago. Updated about 2 years ago.

Status:
New
Priority:
Normal
Assignee:
-
Start date:
04/26/2023
Due date:
% Done:

0%

Estimated time:
Update_emp_insert_emp.txt (1.45 KB) Update_emp_insert_emp.txt Luc Tran Van, 04/26/2023 08:34 AM
empl-data.rar (1.13 MB) empl-data.rar Luc Tran Van, 04/26/2023 08:55 AM
DC_Search.txt (18.8 KB) DC_Search.txt Luc Tran Van, 04/26/2023 08:56 AM
TL_Search.txt (14.7 KB) TL_Search.txt Luc Tran Van, 04/26/2023 08:56 AM
KH_Lui.txt (8.29 KB) KH_Lui.txt Luc Tran Van, 04/26/2023 09:18 AM
ADDNEW_KT.txt (36.4 KB) ADDNEW_KT.txt Luc Tran Van, 04/26/2023 09:18 AM
USE_KT.txt (27.9 KB) USE_KT.txt Luc Tran Van, 04/26/2023 09:18 AM
search_XSD_TH.txt (38.3 KB) search_XSD_TH.txt Luc Tran Van, 04/26/2023 09:37 AM
ASS_NEW_SEARCH.txt (25.7 KB) ASS_NEW_SEARCH.txt Luc Tran Van, 04/26/2023 09:46 AM
KT.rar (35.4 KB) KT.rar Luc Tran Van, 04/26/2023 11:43 AM
cmel-data.txt (137 KB) cmel-data.txt Luc Tran Van, 04/26/2023 03:27 PM

History

#2 Updated by Luc Tran Van about 2 years ago

EXEC dbo.sp_generate_inserts @table_name = 'CM_EMPLOYEE_SYNC', -- varchar(776)
@from = 'FROM CM_EMPLOYEE_SYNC' -- varchar(800)

#8 Updated by Luc Tran Van about 2 years ago

#9 Updated by Luc Tran Van about 2 years ago

UPDATE CM_EMPLOYEE_LOG SET DEP_CODE = '05Q01' WHERE USER_DOMAIN = 'nghiamc'
UPDATE CM_EMPLOYEE SET DEP_ID = 'DEP000000000085' WHERE EMP_CODE = '0000-16263'
UPDATE TL_USER SET DEP_ID = 'DEP000000000085', SECUR_CODE = 'DEP000000000085' WHERE TLNANME = 'nghiamc'
UPDATE TR_REQUEST_SHOP_DOC SET DEP_ID = 'DEP000000000085' WHERE REQ_ID = 'REQ_ID'

Also available in: Atom PDF