Project

General

Profile

UPDATE_SERI.txt

Luc Tran Van, 05/05/2023 01:49 PM

 
1
UPDATE ASS_MASTER SET ASSET_SERIAL_NO =NULL WHERE ASSET_CODE='1157038_19'
2
UPDATE ASS_MASTER SET ASSET_SERIAL_NO =NULL WHERE ASSET_CODE='1157038_16'
3
UPDATE ASS_MASTER SET ASSET_SERIAL_NO =NULL WHERE ASSET_CODE='1157038_15'
4
UPDATE ASS_MASTER SET ASSET_SERIAL_NO =NULL WHERE ASSET_CODE='1157038_14'
5
UPDATE ASS_MASTER SET ASSET_SERIAL_NO =NULL WHERE ASSET_CODE='1157038_13'
6
UPDATE ASS_MASTER SET ASSET_SERIAL_NO =NULL WHERE ASSET_CODE='1157038_12'
7
UPDATE ASS_MASTER SET ASSET_SERIAL_NO =NULL WHERE ASSET_CODE='1157038_11'
8
UPDATE ASS_MASTER SET ASSET_SERIAL_NO =NULL WHERE ASSET_CODE='1157038_10'
9
UPDATE ASS_MASTER SET ASSET_SERIAL_NO =NULL WHERE ASSET_CODE='1157038_9'
10
UPDATE ASS_MASTER SET ASSET_SERIAL_NO =NULL WHERE ASSET_CODE='1157038_8'
11
UPDATE ASS_MASTER SET ASSET_SERIAL_NO =NULL WHERE ASSET_CODE='1157038_7'
12
UPDATE ASS_MASTER SET ASSET_SERIAL_NO =NULL WHERE ASSET_CODE='1157038_6'
13
UPDATE ASS_MASTER SET ASSET_SERIAL_NO =NULL WHERE ASSET_CODE='1157038_5'
14
UPDATE ASS_MASTER SET ASSET_SERIAL_NO =NULL WHERE ASSET_CODE='1157038_4'
15
UPDATE ASS_MASTER SET ASSET_SERIAL_NO =NULL WHERE ASSET_CODE='1157038_3'
16
UPDATE ASS_MASTER SET ASSET_SERIAL_NO =NULL WHERE ASSET_CODE='1157038_2'
17
UPDATE ASS_MASTER SET ASSET_SERIAL_NO =NULL WHERE ASSET_CODE='1157038_1'
18
UPDATE ASS_MASTER SET ASSET_SERIAL_NO =N'7V897J3' WHERE ASSET_CODE='1339608_79'
19
UPDATE ASS_MASTER SET ASSET_SERIAL_NO =N'81GB7J3' WHERE ASSET_CODE='1339608_78'
20
UPDATE ASS_MASTER SET ASSET_SERIAL_NO =N'7V9B7J3' WHERE ASSET_CODE='1339608_77'
21
UPDATE ASS_MASTER SET ASSET_SERIAL_NO =N'8S1XTF3' WHERE ASSET_CODE='1339608_76'
22
UPDATE ASS_MASTER SET ASSET_SERIAL_NO =N'8H3WTF3' WHERE ASSET_CODE='1339608_75'
23
UPDATE ASS_MASTER SET ASSET_SERIAL_NO =N'8S6XTF3' WHERE ASSET_CODE='1339608_74'
24
UPDATE ASS_MASTER SET ASSET_SERIAL_NO =N'8S7XTF3' WHERE ASSET_CODE='1339608_73'
25
UPDATE ASS_MASTER SET ASSET_SERIAL_NO =N'8N9XTF3' WHERE ASSET_CODE='1339608_72'
26
UPDATE ASS_MASTER SET ASSET_SERIAL_NO =N'68STTF3' WHERE ASSET_CODE='1339608_71'
27
UPDATE ASS_MASTER SET ASSET_SERIAL_NO =N'68XWT3' WHERE ASSET_CODE='1339608_70'
28
UPDATE ASS_MASTER SET ASSET_SERIAL_NO =N'8S8VTF3' WHERE ASSET_CODE='1339608_69'
29
UPDATE ASS_MASTER SET ASSET_SERIAL_NO =N'8H0WTF3' WHERE ASSET_CODE='1339608_68'
30
UPDATE ASS_MASTER SET ASSET_SERIAL_NO =N'68GVTF3' WHERE ASSET_CODE='1339608_67'
31
UPDATE ASS_MASTER SET ASSET_SERIAL_NO =N'6NVTTF3' WHERE ASSET_CODE='1339608_66'
32
UPDATE ASS_MASTER SET ASSET_SERIAL_NO =N'6NGTTF3' WHERE ASSET_CODE='1339608_65'
33
UPDATE ASS_MASTER SET ASSET_SERIAL_NO =N'6NGTTF3' WHERE ASSET_CODE='1339608_64'
34
UPDATE ASS_MASTER SET ASSET_SERIAL_NO =N'7VKB7J3' WHERE ASSET_CODE='1339608_63'
35
UPDATE ASS_MASTER SET ASSET_SERIAL_NO =N'8GQTTF3' WHERE ASSET_CODE='1339608_15'