--patient
begin transaction;
DELETE FROM patient where patientno = 'DA_100905003';
DELETE FROM patient where patientno = 'DA_100909007';
DELETE FROM patient where patientno = 'DA_100912003';
DELETE FROM patient where patientno = 'DA_100912008';
DELETE FROM patient where patientno = 'DA_100916008';
DELETE FROM patient where patientno = 'DA_100922002';
DELETE FROM patient where patientno = 'DA_100922006';
DELETE FROM patient where patientno = 'DA_100923005';
DELETE FROM patient where patientno = 'DA_100925006';
DELETE FROM patient where patientno = 'DA_100925013';
DELETE FROM patient where patientno = 'DA_100929005';
DELETE FROM patient where patientno = 'DA_101009006';
DELETE FROM patient where patientno = 'DA_101009009';
DELETE FROM patient where patientno = 'DA_101010009';
DELETE FROM patient where patientno = 'DA_101011002';
DELETE FROM patient where patientno = 'DA_101011003';
DELETE FROM patient where patientno = 'DA_101011004';
DELETE FROM patient where patientno = 'DA_101011005';
DELETE FROM patient where patientno = 'DA_101016008';
DELETE FROM patient where patientno = 'DA_101018001';
DELETE FROM patient where patientno = 'DA_101018002';
DELETE FROM patient where patientno = 'DA_101021002';
DELETE FROM patient where patientno = 'DA_101023007';
DELETE FROM patient where patientno = 'DA_101023012';
DELETE FROM patient where patientno = 'DA_101023013';
DELETE FROM patient where patientno = 'DA_101023014';
DELETE FROM patient where patientno = 'DA_101024001';
DELETE FROM patient where patientno = 'DA_101024003';
DELETE FROM patient where patientno = 'DA_101024011';
DELETE FROM patient where patientno = 'DA_101024016';
DELETE FROM patient where patientno = 'DA_101025006';
DELETE FROM patient where patientno = 'DA_101030007';
DELETE FROM patient where patientno = 'DA_101030010';
DELETE FROM patient where patientno = 'DA_101030014';
DELETE FROM patient where patientno = 'DA_101104006';
DELETE FROM patient where patientno = 'DA_101104009';
DELETE FROM patient where patientno = 'DA_101104012';
DELETE FROM patient where patientno = 'DA_101104019';
DELETE FROM patient where patientno = 'DA_101105001';
DELETE FROM patient where patientno = 'DA_101105002';
DELETE FROM patient where patientno = 'DA_101105003';
DELETE FROM patient where patientno = 'DA_101105006';
DELETE FROM patient where patientno = 'DA_101106006';
DELETE FROM patient where patientno = 'DA_101106011';
DELETE FROM patient where patientno = 'DA_101106012';
DELETE FROM patient where patientno = 'DA_101106014';
DELETE FROM patient where patientno = 'DA_101106022';
DELETE FROM patient where patientno = 'DA_101107003';
DELETE FROM patient where patientno = 'DA_101107006';
DELETE FROM patient where patientno = 'DA_101107015';
DELETE FROM patient where patientno = 'DA_101107017';
DELETE FROM patient where patientno = 'DA_101107018';
DELETE FROM patient where patientno = 'DA_101107025';
DELETE FROM patient where patientno = 'DA_101108002';
DELETE FROM patient where patientno = 'DA_101108011';
DELETE FROM patient where patientno = 'DA_101108012';
DELETE FROM patient where patientno = 'DA_101108014';
DELETE FROM patient where patientno = 'DA_101111007';
DELETE FROM patient where patientno = 'DA_101111009';
DELETE FROM patient where patientno = 'DA_101111011';
DELETE FROM patient where patientno = 'DA_101111013';
DELETE FROM patient where patientno = 'DA_101113001';
DELETE FROM patient where patientno = 'DA_101113002';
DELETE FROM patient where patientno = 'DA_101113003';
DELETE FROM patient where patientno = 'DA_101113008';
DELETE FROM patient where patientno = 'DA_101113009';
DELETE FROM patient where patientno = 'DA_101113013';
DELETE FROM patient where patientno = 'DA_101114002';
DELETE FROM patient where patientno = 'DA_101114003';
DELETE FROM patient where patientno = 'DA_101114012';
commit transaction;

--patientexamine
begin transaction;
DELETE FROM patientexamine where patientno = 'DA_100905003';
DELETE FROM patientexamine where patientno = 'DA_100909007';
DELETE FROM patientexamine where patientno = 'DA_100912003';
DELETE FROM patientexamine where patientno = 'DA_100912008';
DELETE FROM patientexamine where patientno = 'DA_100916008';
DELETE FROM patientexamine where patientno = 'DA_100922002';
DELETE FROM patientexamine where patientno = 'DA_100922006';
DELETE FROM patientexamine where patientno = 'DA_100923005';
DELETE FROM patientexamine where patientno = 'DA_100925006';
DELETE FROM patientexamine where patientno = 'DA_100925013';
DELETE FROM patientexamine where patientno = 'DA_100929005';
DELETE FROM patientexamine where patientno = 'DA_101009006';
DELETE FROM patientexamine where patientno = 'DA_101009009';
DELETE FROM patientexamine where patientno = 'DA_101010009';
DELETE FROM patientexamine where patientno = 'DA_101011002';
DELETE FROM patientexamine where patientno = 'DA_101011003';
DELETE FROM patientexamine where patientno = 'DA_101011004';
DELETE FROM patientexamine where patientno = 'DA_101011005';
DELETE FROM patientexamine where patientno = 'DA_101016008';
DELETE FROM patientexamine where patientno = 'DA_101018001';
DELETE FROM patientexamine where patientno = 'DA_101018002';
DELETE FROM patientexamine where patientno = 'DA_101021002';
DELETE FROM patientexamine where patientno = 'DA_101023007';
DELETE FROM patientexamine where patientno = 'DA_101023012';
DELETE FROM patientexamine where patientno = 'DA_101023013';
DELETE FROM patientexamine where patientno = 'DA_101023014';
DELETE FROM patientexamine where patientno = 'DA_101024001';
DELETE FROM patientexamine where patientno = 'DA_101024003';
DELETE FROM patientexamine where patientno = 'DA_101024011';
DELETE FROM patientexamine where patientno = 'DA_101024016';
DELETE FROM patientexamine where patientno = 'DA_101025006';
DELETE FROM patientexamine where patientno = 'DA_101030007';
DELETE FROM patientexamine where patientno = 'DA_101030010';
DELETE FROM patientexamine where patientno = 'DA_101030014';
DELETE FROM patientexamine where patientno = 'DA_101104006';
DELETE FROM patientexamine where patientno = 'DA_101104009';
DELETE FROM patientexamine where patientno = 'DA_101104012';
DELETE FROM patientexamine where patientno = 'DA_101104019';
DELETE FROM patientexamine where patientno = 'DA_101105001';
DELETE FROM patientexamine where patientno = 'DA_101105002';
DELETE FROM patientexamine where patientno = 'DA_101105003';
DELETE FROM patientexamine where patientno = 'DA_101105006';
DELETE FROM patientexamine where patientno = 'DA_101106006';
DELETE FROM patientexamine where patientno = 'DA_101106011';
DELETE FROM patientexamine where patientno = 'DA_101106012';
DELETE FROM patientexamine where patientno = 'DA_101106014';
DELETE FROM patientexamine where patientno = 'DA_101106022';
DELETE FROM patientexamine where patientno = 'DA_101107003';
DELETE FROM patientexamine where patientno = 'DA_101107006';
DELETE FROM patientexamine where patientno = 'DA_101107015';
DELETE FROM patientexamine where patientno = 'DA_101107017';
DELETE FROM patientexamine where patientno = 'DA_101107018';
DELETE FROM patientexamine where patientno = 'DA_101107025';
DELETE FROM patientexamine where patientno = 'DA_101108002';
DELETE FROM patientexamine where patientno = 'DA_101108011';
DELETE FROM patientexamine where patientno = 'DA_101108012';
DELETE FROM patientexamine where patientno = 'DA_101108014';
DELETE FROM patientexamine where patientno = 'DA_101111007';
DELETE FROM patientexamine where patientno = 'DA_101111009';
DELETE FROM patientexamine where patientno = 'DA_101111011';
DELETE FROM patientexamine where patientno = 'DA_101111013';
DELETE FROM patientexamine where patientno = 'DA_101113001';
DELETE FROM patientexamine where patientno = 'DA_101113002';
DELETE FROM patientexamine where patientno = 'DA_101113003';
DELETE FROM patientexamine where patientno = 'DA_101113008';
DELETE FROM patientexamine where patientno = 'DA_101113009';
DELETE FROM patientexamine where patientno = 'DA_101113013';
DELETE FROM patientexamine where patientno = 'DA_101114002';
DELETE FROM patientexamine where patientno = 'DA_101114003';
DELETE FROM patientexamine where patientno = 'DA_101114012';
commit transaction;