FP_MBD_Database/RAWAT_INAP_UPDATE.sql at master · KresnaAP/FP_MBD_Database · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
UPDATE rawat_inap set id_rekam = 'RM00000001' where id_inap = 'RI00000001';
UPDATE rawat_inap set id_rekam = 'RM00000002' where id_inap = 'RI00000002';
UPDATE rawat_inap set id_rekam = 'RM00000003' where id_inap = 'RI00000003';
UPDATE rawat_inap set id_rekam = 'RM00000004' where id_inap = 'RI00000004';
UPDATE rawat_inap set id_rekam = 'RM00000005' where id_inap = 'RI00000005';
UPDATE rawat_inap set id_rekam = 'RM00000006' where id_inap = 'RI00000006';
UPDATE rawat_inap set id_rekam = 'RM00000007' where id_inap = 'RI00000007';
UPDATE rawat_inap set id_rekam = 'RM00000008' where id_inap = 'RI00000008';
UPDATE rawat_inap set id_rekam = 'RM00000009' where id_inap = 'RI00000009';
UPDATE rawat_inap set id_rekam = 'RM00000010' where id_inap = 'RI00000010';
UPDATE rawat_inap set id_rekam = 'RM00000011' where id_inap = 'RI00000011';
UPDATE rawat_inap set id_rekam = 'RM00000012' where id_inap = 'RI00000012';
UPDATE rawat_inap set id_rekam = 'RM00000013' where id_inap = 'RI00000013';
UPDATE rawat_inap set id_rekam = 'RM00000014' where id_inap = 'RI00000014';
UPDATE rawat_inap set id_rekam = 'RM00000015' where id_inap = 'RI00000015';
UPDATE rawat_inap set id_rekam = 'RM00000016' where id_inap = 'RI00000016';
UPDATE rawat_inap set id_rekam = 'RM00000017' where id_inap = 'RI00000017';
UPDATE rawat_inap set id_rekam = 'RM00000018' where id_inap = 'RI00000018';
UPDATE rawat_inap set id_rekam = 'RM00000019' where id_inap = 'RI00000019';
UPDATE rawat_inap set id_rekam = 'RM00000020' where id_inap = 'RI00000020';
UPDATE rawat_inap set id_rekam = 'RM00000021' where id_inap = 'RI00000021';
UPDATE rawat_inap set id_rekam = 'RM00000022' where id_inap = 'RI00000022';
UPDATE rawat_inap set id_rekam = 'RM00000023' where id_inap = 'RI00000023';
UPDATE rawat_inap set id_rekam = 'RM00000024' where id_inap = 'RI00000024';
UPDATE rawat_inap set id_rekam = 'RM00000025' where id_inap = 'RI00000025';
UPDATE rawat_inap set id_rekam = 'RM00000026' where id_inap = 'RI00000026';
UPDATE rawat_inap set id_rekam = 'RM00000028' where id_inap = 'RI00000027';
UPDATE rawat_inap set id_rekam = 'RM00000029' where id_inap = 'RI00000028';
UPDATE rawat_inap set id_rekam = 'RM00000030' where id_inap = 'RI00000029';
UPDATE rawat_inap set id_rekam = 'RM00000031' where id_inap = 'RI00000030';
UPDATE rawat_inap set id_rekam = 'RM00000032' where id_inap = 'RI00000031';
UPDATE rawat_inap set id_rekam = 'RM00000033' where id_inap = 'RI00000032';
UPDATE rawat_inap set id_rekam = 'RM00000034' where id_inap = 'RI00000033';
UPDATE rawat_inap set id_rekam = 'RM00000035' where id_inap = 'RI00000034';
UPDATE rawat_inap set id_rekam = 'RM00000036' where id_inap = 'RI00000035';
UPDATE rawat_inap set id_rekam = 'RM00000037' where id_inap = 'RI00000036';
UPDATE rawat_inap set id_rekam = 'RM00000038' where id_inap = 'RI00000037';
UPDATE rawat_inap set id_rekam = 'RM00000039' where id_inap = 'RI00000038';
UPDATE rawat_inap set id_rekam = 'RM00000040' where id_inap = 'RI00000039';
UPDATE rawat_inap set id_rekam = 'RM00000041' where id_inap = 'RI00000040';