Help with inserting parent keys into a table

[talder]

Hi All,

I am trying to insert all the parent keys for a given row into a table. I am able to insert all but one key. I am not what I am doing wrong. I have given a detailed description of the problem below along with all the DDL and DML statements that I used.

When I ran the following query, I have seen two part_ids being returned with the respective Q-IDs. However, when I ran the query to populate the parent keys into the target table, I am not seeing anything related to the QID of 73.

SQL> select a.part_id, b.q_id, b.serial_no
from sers a, qtab b
where a.serial_no = b.serial_no
and part_id='100092-E' order by part_id;


100092-E 38 2
100092-E 73 A1-a

SQL> select parent_q_id from pq_tab where q_id = 38;
33
SQL> select parent_q_id from pq_tab where q_id = 33;
1

SQL> select parent_q_id from pq_tab where q_id = 73;
54

I then ran the following SQL.

SQL> select unique sers.part_id,roots.q_id
from (select q_id,
RTRIM (substr(sys_connect_by_path(q_id,','),2,2), ',') root
from pq_tab
start with q_id in
(select q_id
from pq_tab a
where not exists
(select 1
from pq_tab b
where b.parent_q_id = a.q_id))
connect by prior parent_q_id = q_id) roots,
qtab,
sers
where roots.root = qtab.q_id
and qtab.SERIAL_NO = sers.serial_no
and sers.part_id = '100092-E'
order by 2 desc


100092-E 38
100092-E 33
100092-E 1


I did not see any rows for QID of 73. From the given data, I was hoping to see 38,33,1 as well as 73 and 54 in my result set.

Any help you can provide would be greatfully appreciated.

Many thanks,
Thomas D. Alder.

(DDL and DML will be attached to this post)

[talder]

DROP TABLE SERS CASCADE CONSTRAINTS;
DROP TABLE TARGET CASCADE CONSTRAINTS;
DROP TABLE QTAB CASCADE CONSTRAINTS;
DROP TABLE PQ_TAB CASCADE CONSTRAINTS;

create table target (PART_ID VARCHAR2(256), Q_ID NUMBER(38));
create table qtab (Q_ID NUMBER(38), SERIAL_NO VARCHAR2(20));
create table sers (PART_ID VARCHAR2(256), SERIAL_NO VARCHAR2(20));
create table pq_tab (Q_ID NUMBER(38), PARENT_Q_ID NUMBER(38));

ALTER TABLE pq_tab ADD ( PRIMARY KEY (q_id) );
ALTER TABLE qtab ADD ( PRIMARY KEY (q_id,serial_no) );
ALTER TABLE sers ADD ( PRIMARY KEY (part_id, serial_no) ) ;



INSERT INTO PQ_TAB VALUES (63,55);
INSERT INTO PQ_TAB VALUES (64,55);
INSERT INTO PQ_TAB VALUES (65,55);
INSERT INTO PQ_TAB VALUES (66,55);
INSERT INTO PQ_TAB VALUES (67,55);
INSERT INTO PQ_TAB VALUES (68,55);
INSERT INTO PQ_TAB VALUES (69,68);
INSERT INTO PQ_TAB VALUES (70,55);
INSERT INTO PQ_TAB VALUES (71,70);
INSERT INTO PQ_TAB VALUES (72,70);
INSERT INTO PQ_TAB VALUES (73,54);
INSERT INTO PQ_TAB VALUES (74,73);
INSERT INTO PQ_TAB VALUES (75,73);
INSERT INTO PQ_TAB VALUES (76,73);
INSERT INTO PQ_TAB VALUES (77,73);
INSERT INTO PQ_TAB VALUES (78,73);
INSERT INTO PQ_TAB VALUES (79,73);
INSERT INTO PQ_TAB VALUES (80,0);
INSERT INTO PQ_TAB VALUES (81,80);
INSERT INTO PQ_TAB VALUES (82,80);
INSERT INTO PQ_TAB VALUES (83,80);
INSERT INTO PQ_TAB VALUES (84,80);
INSERT INTO PQ_TAB VALUES (41,33);
INSERT INTO PQ_TAB VALUES (42,33);
INSERT INTO PQ_TAB VALUES (43,42);
INSERT INTO PQ_TAB VALUES (44,42);
INSERT INTO PQ_TAB VALUES (45,0);
INSERT INTO PQ_TAB VALUES (46,45);
INSERT INTO PQ_TAB VALUES (47,45);
INSERT INTO PQ_TAB VALUES (48,45);
INSERT INTO PQ_TAB VALUES (49,0);
INSERT INTO PQ_TAB VALUES (50,49);
INSERT INTO PQ_TAB VALUES (51,50);
INSERT INTO PQ_TAB VALUES (52,50);
INSERT INTO PQ_TAB VALUES (53,50);
INSERT INTO PQ_TAB VALUES (54,0);
INSERT INTO PQ_TAB VALUES (55,54);
INSERT INTO PQ_TAB VALUES (56,55);
INSERT INTO PQ_TAB VALUES (57,55);
INSERT INTO PQ_TAB VALUES (58,55);
INSERT INTO PQ_TAB VALUES (59,55);
INSERT INTO PQ_TAB VALUES (60,55);
INSERT INTO PQ_TAB VALUES (61,55);
INSERT INTO PQ_TAB VALUES (62,55);
INSERT INTO PQ_TAB VALUES (1,0);
INSERT INTO PQ_TAB VALUES (2,1);
INSERT INTO PQ_TAB VALUES (3,2);
INSERT INTO PQ_TAB VALUES (4,2);
INSERT INTO PQ_TAB VALUES (5,2);
INSERT INTO PQ_TAB VALUES (6,2);
INSERT INTO PQ_TAB VALUES (7,2);
INSERT INTO PQ_TAB VALUES (8,2);
INSERT INTO PQ_TAB VALUES (9,2);
INSERT INTO PQ_TAB VALUES (10,2);
INSERT INTO PQ_TAB VALUES (11,2);
INSERT INTO PQ_TAB VALUES (12,11);
INSERT INTO PQ_TAB VALUES (13,11);
INSERT INTO PQ_TAB VALUES (14,11);
INSERT INTO PQ_TAB VALUES (15,11);
INSERT INTO PQ_TAB VALUES (16,11);
INSERT INTO PQ_TAB VALUES (17,2);
INSERT INTO PQ_TAB VALUES (18,17);
INSERT INTO PQ_TAB VALUES (19,17);
INSERT INTO PQ_TAB VALUES (20,17);
INSERT INTO PQ_TAB VALUES (21,2);
INSERT INTO PQ_TAB VALUES (22,2);
INSERT INTO PQ_TAB VALUES (23,22);
INSERT INTO PQ_TAB VALUES (24,22);
INSERT INTO PQ_TAB VALUES (25,2);
INSERT INTO PQ_TAB VALUES (26,2);
INSERT INTO PQ_TAB VALUES (27,1);
INSERT INTO PQ_TAB VALUES (28,27);
INSERT INTO PQ_TAB VALUES (29,27);
INSERT INTO PQ_TAB VALUES (30,29);
INSERT INTO PQ_TAB VALUES (31,27);
INSERT INTO PQ_TAB VALUES (32,31);
INSERT INTO PQ_TAB VALUES (33, 1);
INSERT INTO PQ_TAB VALUES (34,33);
INSERT INTO PQ_TAB VALUES (35,33);
INSERT INTO PQ_TAB VALUES (36,33);
INSERT INTO PQ_TAB VALUES (37,33);
INSERT INTO PQ_TAB VALUES (38,33);
INSERT INTO PQ_TAB VALUES (39,33);
INSERT INTO PQ_TAB VALUES (40,33);

[talder]

INSERT INTO SERS VALUES ('100000-A', '15');
INSERT INTO SERS VALUES ('100000-A','A1-b');
INSERT INTO SERS VALUES ('100002-A','8');
INSERT INTO SERS VALUES ('100002-A','A1-a');
INSERT INTO SERS VALUES ('100002-A','A2-a');
INSERT INTO SERS VALUES ('100002-A','A3-a');
INSERT INTO SERS VALUES ('100002-A','A5');
INSERT INTO SERS VALUES ('100002-A','A7-a');
INSERT INTO SERS VALUES ('100002-A','PR16');
INSERT INTO SERS VALUES ('100002-A','PR19');
INSERT INTO SERS VALUES ('100002-A','PR2');
INSERT INTO SERS VALUES ('100002-A','PR34');
INSERT INTO SERS VALUES ('100004-A','A1-b');
INSERT INTO SERS VALUES ('100004-A','A10');
INSERT INTO SERS VALUES ('100004-A','A11');
INSERT INTO SERS VALUES ('100004-A','PR12');
INSERT INTO SERS VALUES ('100004-A','PR34');
INSERT INTO SERS VALUES ('100004-A','PR38');
INSERT INTO SERS VALUES ('100004-A','S1');
INSERT INTO SERS VALUES ('100005-A','12');
INSERT INTO SERS VALUES ('100005-A','A11');
INSERT INTO SERS VALUES ('100006-A','15');
INSERT INTO SERS VALUES ('100007-A','15');
INSERT INTO SERS VALUES ('100007-A','A1-a');
INSERT INTO SERS VALUES ('100008-A','15');
INSERT INTO SERS VALUES ('100008-A','A1-b');
INSERT INTO SERS VALUES ('100009-A','15');
INSERT INTO SERS VALUES ('100010-A','6');
INSERT INTO SERS VALUES ('100011-A','A11');
INSERT INTO SERS VALUES ('100011-A','A3-a');
INSERT INTO SERS VALUES ('100011-A','PR8');
INSERT INTO SERS VALUES ('100012-A','A4');
INSERT INTO SERS VALUES ('100013-A','A1-b');
INSERT INTO SERS VALUES ('100014-A','15');
INSERT INTO SERS VALUES ('100014-A','A1-b');
INSERT INTO SERS VALUES ('100015-A','A3-a');
INSERT INTO SERS VALUES ('100016-A','15');
INSERT INTO SERS VALUES ('100016-A','PR15');
INSERT INTO SERS VALUES ('100016-A','PR23');
INSERT INTO SERS VALUES ('100016-A','S11');
INSERT INTO SERS VALUES ('100016-A','S4');
INSERT INTO SERS VALUES ('100017-A','15');
INSERT INTO SERS VALUES ('100017-A','PR15');
INSERT INTO SERS VALUES ('100017-A','PR23');
INSERT INTO SERS VALUES ('100017-A','S4');
INSERT INTO SERS VALUES ('100018-A','15');
INSERT INTO SERS VALUES ('100018-A','A1-b');
INSERT INTO SERS VALUES ('100019-A','15');
INSERT INTO SERS VALUES ('100019-A','A1-b');
INSERT INTO SERS VALUES ('100020-A','15');
INSERT INTO SERS VALUES ('100020-A','A1-b');
INSERT INTO SERS VALUES ('100022-A','13');
INSERT INTO SERS VALUES ('100023-A','13');
INSERT INTO SERS VALUES ('100023-A','A1-b');
INSERT INTO SERS VALUES ('100024-A','A1-a');
INSERT INTO SERS VALUES ('100024-A','A11');
INSERT INTO SERS VALUES ('100024-A','A3-a');
INSERT INTO SERS VALUES ('100024-A','PR10');
INSERT INTO SERS VALUES ('100024-A','PR14');
INSERT INTO SERS VALUES ('100024-A','PR17');
INSERT INTO SERS VALUES ('100024-A','PR20');
INSERT INTO SERS VALUES ('100024-A','PR21');
INSERT INTO SERS VALUES ('100024-A','PR23');
INSERT INTO SERS VALUES ('100025-A','15');
INSERT INTO SERS VALUES ('100025-A','A1-b');
INSERT INTO SERS VALUES ('100026-A','13');
INSERT INTO SERS VALUES ('100026-A','A1-b');

[talder]

INSERT INTO SERS VALUES ('100027-A','15');
INSERT INTO SERS VALUES ('100027-A','A1-b');
INSERT INTO SERS VALUES ('100028-A','15');
INSERT INTO SERS VALUES ('100028-A','A1-b');
INSERT INTO SERS VALUES ('100030-A','15');
INSERT INTO SERS VALUES ('100030-A','A3-a');
INSERT INTO SERS VALUES ('100030-A','PR29');
INSERT INTO SERS VALUES ('100031-A','15');
INSERT INTO SERS VALUES ('100031-A','PR23');
INSERT INTO SERS VALUES ('100032-A','15');
INSERT INTO SERS VALUES ('100032-A','A1-a');
INSERT INTO SERS VALUES ('100032-A','A3-a');
INSERT INTO SERS VALUES ('100032-A','MC');
INSERT INTO SERS VALUES ('100032-A','PR21');
INSERT INTO SERS VALUES ('100032-A','S3');
INSERT INTO SERS VALUES ('100032-A','S8');
INSERT INTO SERS VALUES ('100034-A','15');
INSERT INTO SERS VALUES ('100035-A','15');
INSERT INTO SERS VALUES ('100036-A','15');
INSERT INTO SERS VALUES ('100036-A','A1-b');
INSERT INTO SERS VALUES ('100037-A','15');
INSERT INTO SERS VALUES ('100037-A','A1-b');
INSERT INTO SERS VALUES ('100038-A','15');
INSERT INTO SERS VALUES ('100038-A','A1-b');
INSERT INTO SERS VALUES ('100040-A','11');
INSERT INTO SERS VALUES ('100040-A','A11');
INSERT INTO SERS VALUES ('100040-A','A2-b');
INSERT INTO SERS VALUES ('100040-A','A3-a');
INSERT INTO SERS VALUES ('100040-A','S10');
INSERT INTO SERS VALUES ('100041-A','A1-a');
INSERT INTO SERS VALUES ('100041-A','PR27');
INSERT INTO SERS VALUES ('100041-A','S1');
INSERT INTO SERS VALUES ('100041-A','S11');
INSERT INTO SERS VALUES ('100042-A','15');
INSERT INTO SERS VALUES ('100042-A','A11');
INSERT INTO SERS VALUES ('100042-A','A3-a');
INSERT INTO SERS VALUES ('100042-A','PR23');
INSERT INTO SERS VALUES ('100042-A','S11');
INSERT INTO SERS VALUES ('100044-A','11');
INSERT INTO SERS VALUES ('100044-A','A11');
INSERT INTO SERS VALUES ('100044-A','A2-b');
INSERT INTO SERS VALUES ('100044-A','A3-a');
INSERT INTO SERS VALUES ('100044-A','S10');
INSERT INTO SERS VALUES ('100045-A','1');
INSERT INTO SERS VALUES ('100045-A','A1-a');
INSERT INTO SERS VALUES ('100047-A','3');
INSERT INTO SERS VALUES ('100047-A','A1-a');
INSERT INTO SERS VALUES ('100047-B','3');
INSERT INTO SERS VALUES ('100047-B','A1-a');
INSERT INTO SERS VALUES ('100048-A','1');
INSERT INTO SERS VALUES ('100048-A','A1-a');
INSERT INTO SERS VALUES ('100049-A','15');
INSERT INTO SERS VALUES ('100049-A','A3-b');
INSERT INTO SERS VALUES ('100049-A','A7-a');
INSERT INTO SERS VALUES ('100049-A','S6');
INSERT INTO SERS VALUES ('100049-B','15');
INSERT INTO SERS VALUES ('100049-B','A1-a');
INSERT INTO SERS VALUES ('100049-B','A3-b');
INSERT INTO SERS VALUES ('100049-B','A7-a');
INSERT INTO SERS VALUES ('100049-B','S6');
INSERT INTO SERS VALUES ('100050-A','3');
INSERT INTO SERS VALUES ('100051-A','15');
INSERT INTO SERS VALUES ('100051-A','A1-b');
INSERT INTO SERS VALUES ('100052-A','15');
INSERT INTO SERS VALUES ('100052-A','A1-b');
INSERT INTO SERS VALUES ('100053-A','7');
INSERT INTO SERS VALUES ('100054-A','15');
INSERT INTO SERS VALUES ('100054-A','A1-b');
INSERT INTO SERS VALUES ('100055-A','15');
INSERT INTO SERS VALUES ('100055-A','PR2');
INSERT INTO SERS VALUES ('100055-A','S1');
INSERT INTO SERS VALUES ('100055-A','S11');
INSERT INTO SERS VALUES ('100056-A','6');
INSERT INTO SERS VALUES ('100056-A','A1-a');
INSERT INTO SERS VALUES ('100056-B','6');
INSERT INTO SERS VALUES ('100056-B','A1-a');
INSERT INTO SERS VALUES ('100056-C','6');
INSERT INTO SERS VALUES ('100056-C','A1-a');
INSERT INTO SERS VALUES ('100056-C','A3-a');
INSERT INTO SERS VALUES ('100058-A','15');
INSERT INTO SERS VALUES ('100058-A','A3-a');
INSERT INTO SERS VALUES ('100058-A','PR11');

[talder]

INSERT INTO SERS VALUES ('100058-A','S1');
INSERT INTO SERS VALUES ('100058-A','S11');
INSERT INTO SERS VALUES ('100059-A','PR11');
INSERT INTO SERS VALUES ('100060-A','15');
INSERT INTO SERS VALUES ('100060-A','A1-b');
INSERT INTO SERS VALUES ('100061-A','15');
INSERT INTO SERS VALUES ('100061-A','S1');
INSERT INTO SERS VALUES ('100061-A','S11');
INSERT INTO SERS VALUES ('100062-A','15');
INSERT INTO SERS VALUES ('100062-A','A1-b');
INSERT INTO SERS VALUES ('100064-A','15');
INSERT INTO SERS VALUES ('100064-A','A11');
INSERT INTO SERS VALUES ('100064-A','A3-b');
INSERT INTO SERS VALUES ('100064-B','15');
INSERT INTO SERS VALUES ('100064-B','A11');
INSERT INTO SERS VALUES ('100065-A','13');
INSERT INTO SERS VALUES ('100065-A','A1-b');
INSERT INTO SERS VALUES ('100065-B','13');
INSERT INTO SERS VALUES ('100065-B','A1-b');
INSERT INTO SERS VALUES ('100066-A','13');
INSERT INTO SERS VALUES ('100066-A','A1-b');
INSERT INTO SERS VALUES ('100067-A','15');
INSERT INTO SERS VALUES ('100067-A','A1-b');
INSERT INTO SERS VALUES ('100068-A','15');
INSERT INTO SERS VALUES ('100068-A','A1-b');
INSERT INTO SERS VALUES ('100068-A','A3-a');
INSERT INTO SERS VALUES ('100068-A','PR12');
INSERT INTO SERS VALUES ('100069-A','15');
INSERT INTO SERS VALUES ('100069-A','PR20');
INSERT INTO SERS VALUES ('100069-A','PR21');
INSERT INTO SERS VALUES ('100069-A','S2');
INSERT INTO SERS VALUES ('100070-A','15');
INSERT INTO SERS VALUES ('100070-A','A1-b');
INSERT INTO SERS VALUES ('100071-A','15');
INSERT INTO SERS VALUES ('100071-A','PR20');
INSERT INTO SERS VALUES ('100071-A','PR21');
INSERT INTO SERS VALUES ('100071-A','S2');
INSERT INTO SERS VALUES ('100072-A','15');
INSERT INTO SERS VALUES ('100072-A','A1-b');
INSERT INTO SERS VALUES ('100073-A','15');
INSERT INTO SERS VALUES ('100073-A','A1-b');
INSERT INTO SERS VALUES ('100074-A','A1-b');
INSERT INTO SERS VALUES ('100074-A','A3-a');
INSERT INTO SERS VALUES ('100074-A','PR12');
INSERT INTO SERS VALUES ('100074-A','PR19');
INSERT INTO SERS VALUES ('100074-A','PR21');
INSERT INTO SERS VALUES ('100074-A','S3');
INSERT INTO SERS VALUES ('100075-A','15');
INSERT INTO SERS VALUES ('100075-A','A1-b');
INSERT INTO SERS VALUES ('100076-A','13');
INSERT INTO SERS VALUES ('100076-A','PR21');
INSERT INTO SERS VALUES ('100076-A','PR23');
INSERT INTO SERS VALUES ('100076-A','S10');
INSERT INTO SERS VALUES ('100076-A','S11');
INSERT INTO SERS VALUES ('100077-A','15');
INSERT INTO SERS VALUES ('100077-A','A1-a');
INSERT INTO SERS VALUES ('100077-A','A11');
INSERT INTO SERS VALUES ('100077-A','A3-a');
INSERT INTO SERS VALUES ('100077-A','PR17');
INSERT INTO SERS VALUES ('100077-A','PR9A-1');
INSERT INTO SERS VALUES ('100077-A','S11');
INSERT INTO SERS VALUES ('100078-A','15');
INSERT INTO SERS VALUES ('100078-A','A1-a');
INSERT INTO SERS VALUES ('100078-A','A3-a');
INSERT INTO SERS VALUES ('100078-A','A5');
INSERT INTO SERS VALUES ('100078-A','PR27');
INSERT INTO SERS VALUES ('100078-A','S2');
INSERT INTO SERS VALUES ('100079-A','13');
INSERT INTO SERS VALUES ('100079-A','A1-b');
INSERT INTO SERS VALUES ('100079-B','13');
INSERT INTO SERS VALUES ('100079-B','A1-b');
INSERT INTO SERS VALUES ('100080-A','3');
INSERT INTO SERS VALUES ('100087-A','15');
INSERT INTO SERS VALUES ('100087-A','A1-b');
INSERT INTO SERS VALUES ('100089-A','PR9A-2');
INSERT INTO SERS VALUES ('100090-A','A3-a');
INSERT INTO SERS VALUES ('100090-A','S2');
INSERT INTO SERS VALUES ('100090-A','S3');
INSERT INTO SERS VALUES ('100091-A','15');
INSERT INTO SERS VALUES ('100091-A','A1-b');
INSERT INTO SERS VALUES ('100092-A','2');
INSERT INTO SERS VALUES ('100092-A','A1-a');
INSERT INTO SERS VALUES ('100092-A','S5');
INSERT INTO SERS VALUES ('100092-A','S6');
INSERT INTO SERS VALUES ('100092-B','2');
INSERT INTO SERS VALUES ('100092-B','A1-a');
INSERT INTO SERS VALUES ('100092-B','A3-b');
INSERT INTO SERS VALUES ('100092-B','A8');
INSERT INTO SERS VALUES ('100092-B','S5');
INSERT INTO SERS VALUES ('100092-B','S6');
INSERT INTO SERS VALUES ('100092-C','2');
INSERT INTO SERS VALUES ('100092-C','A1-a');
INSERT INTO SERS VALUES ('100092-C','A3-b');
INSERT INTO SERS VALUES ('100092-C','A8');
INSERT INTO SERS VALUES ('100092-D','2');
INSERT INTO SERS VALUES ('100092-D','A1-a');
INSERT INTO SERS VALUES ('100092-D','A3-b');
INSERT INTO SERS VALUES ('100092-E','2');
INSERT INTO SERS VALUES ('100092-E','A1-a');
INSERT INTO SERS VALUES ('100094-A','2');
INSERT INTO SERS VALUES ('100094-A','A1-a');
INSERT INTO SERS VALUES ('100094-A','A7-a');
INSERT INTO SERS VALUES ('100094-B','2');
INSERT INTO SERS VALUES ('100094-B','A1-a');
INSERT INTO SERS VALUES ('100094-B','A10');
INSERT INTO SERS VALUES ('100094-B','A7-a');
INSERT INTO SERS VALUES ('100095-A','3');
INSERT INTO SERS VALUES ('100095-A','A1-a');
INSERT INTO SERS VALUES ('100095-A','S8');
INSERT INTO SERS VALUES ('100096-A','15');
INSERT INTO SERS VALUES ('100096-A','A1-a');
INSERT INTO SERS VALUES ('100096-A','A11');
INSERT INTO SERS VALUES ('100096-A','A3-a');
INSERT INTO SERS VALUES ('100098-A','15');
INSERT INTO SERS VALUES ('100098-A','PR14');
INSERT INTO SERS VALUES ('100098-A','PR20');
INSERT INTO SERS VALUES ('100099-A','15');
INSERT INTO SERS VALUES ('100099-A','PR14');
INSERT INTO SERS VALUES ('100099-A','PR20');
INSERT INTO SERS VALUES ('100100-A','15');
INSERT INTO SERS VALUES ('100100-A','PR14');
INSERT INTO SERS VALUES ('100100-A','PR20');
INSERT INTO SERS VALUES ('100101-A','15');
INSERT INTO SERS VALUES ('100101-A','PR14');
INSERT INTO SERS VALUES ('100101-A','PR20');
INSERT INTO SERS VALUES ('100102-A','15');
INSERT INTO SERS VALUES ('100102-A','PR14');
INSERT INTO SERS VALUES ('100102-A','PR20');
INSERT INTO SERS VALUES ('100103-A','15');
INSERT INTO SERS VALUES ('100103-A','PR14');
INSERT INTO SERS VALUES ('100103-A','PR20');
INSERT INTO SERS VALUES ('100104-A','15');
INSERT INTO SERS VALUES ('100104-A','PR15');
INSERT INTO SERS VALUES ('100104-A','PR20');
INSERT INTO SERS VALUES ('100105-A','15');
INSERT INTO SERS VALUES ('100105-A','A1-b');
INSERT INTO SERS VALUES ('100106-A','15');
INSERT INTO SERS VALUES ('100106-A','PR15');
INSERT INTO SERS VALUES ('100106-A','PR20');
INSERT INTO SERS VALUES ('100107-A','15');
INSERT INTO SERS VALUES ('100107-A','PR15');
INSERT INTO SERS VALUES ('100107-A','PR20');
INSERT INTO SERS VALUES ('100108-A','15');
INSERT INTO SERS VALUES ('100108-A','PR15');
INSERT INTO SERS VALUES ('100108-A','PR20');
INSERT INTO SERS VALUES ('100109-A','15');
INSERT INTO SERS VALUES ('100109-A','PR20');
INSERT INTO SERS VALUES ('100109-A','S11');
INSERT INTO SERS VALUES ('100110-A','15');
INSERT INTO SERS VALUES ('100110-A','A10');
INSERT INTO SERS VALUES ('100110-A','PR14');
INSERT INTO SERS VALUES ('100110-A','PR17');
INSERT INTO SERS VALUES ('100111-A','15');
INSERT INTO SERS VALUES ('100111-A','PR14');
INSERT INTO SERS VALUES ('100111-A','PR17');
INSERT INTO SERS VALUES ('100112-A','1');
INSERT INTO SERS VALUES ('100112-A','13');
INSERT INTO SERS VALUES ('100112-A','A5');
INSERT INTO SERS VALUES ('100112-A','PR15');
INSERT INTO SERS VALUES ('100112-A','PR21');
INSERT INTO SERS VALUES ('100112-A','PR23');
INSERT INTO SERS VALUES ('100112-A','S1');
INSERT INTO SERS VALUES ('100112-A','S10');
INSERT INTO SERS VALUES ('100112-A','S3');
INSERT INTO SERS VALUES ('100112-B','13');
INSERT INTO SERS VALUES ('100112-B','A5');
INSERT INTO SERS VALUES ('100112-B','PR15');
INSERT INTO SERS VALUES ('100112-B','PR21');
INSERT INTO SERS VALUES ('100112-B','PR23');
INSERT INTO SERS VALUES ('100112-B','S1');
INSERT INTO SERS VALUES ('100112-B','S10');
INSERT INTO SERS VALUES ('100112-B','S3');
INSERT INTO SERS VALUES ('100113-A','15');
INSERT INTO SERS VALUES ('100113-A','A1-b');
INSERT INTO SERS VALUES ('100114-A','1');
INSERT INTO SERS VALUES ('100114-A','2');
INSERT INTO SERS VALUES ('100114-A','A1-a');
INSERT INTO SERS VALUES ('100114-A','A11');
INSERT INTO SERS VALUES ('100115-A','15');
INSERT INTO SERS VALUES ('100115-A','A10');
INSERT INTO SERS VALUES ('100116-A','15');
INSERT INTO SERS VALUES ('100116-A','A1-b');
INSERT INTO SERS VALUES ('100118-A','PR28');
INSERT INTO SERS VALUES ('100119-A','6');
INSERT INTO SERS VALUES ('100120-A','15');
INSERT INTO SERS VALUES ('100120-A','A1-b');
INSERT INTO SERS VALUES ('100121-A','15');
INSERT INTO SERS VALUES ('100121-A','A1-b');
INSERT INTO SERS VALUES ('100122-A','15');
INSERT INTO SERS VALUES ('100122-A','A1-b');
INSERT INTO SERS VALUES ('100123-A','13');
INSERT INTO SERS VALUES ('100123-A','A1-b');
INSERT INTO SERS VALUES ('100124-A','13');
INSERT INTO SERS VALUES ('100124-A','A1-b');

[talder]

INSERT INTO QTAB VALUES (5,'A10');
INSERT INTO QTAB VALUES (6,'PR13');
INSERT INTO QTAB VALUES (7,'PR14');
INSERT INTO QTAB VALUES (8,'PR15');
INSERT INTO QTAB VALUES (9,'PR17');
INSERT INTO QTAB VALUES (10,'PR20');
INSERT INTO QTAB VALUES (11,'PR21');
INSERT INTO QTAB VALUES (12,'PR21');
INSERT INTO QTAB VALUES (13,'PR21');
INSERT INTO QTAB VALUES (14,'PR21');
INSERT INTO QTAB VALUES (15,'PR21');
INSERT INTO QTAB VALUES (16,'PR21');
INSERT INTO QTAB VALUES (17,'PR23');
INSERT INTO QTAB VALUES (18,'PR23');
INSERT INTO QTAB VALUES (19,'PR23');
INSERT INTO QTAB VALUES (20,'PR23');
INSERT INTO QTAB VALUES (21,'PR26');
INSERT INTO QTAB VALUES (22,'PR27');
INSERT INTO QTAB VALUES (23,'PR27');
INSERT INTO QTAB VALUES (24,'PR27');
INSERT INTO QTAB VALUES (25,'PR27');
INSERT INTO QTAB VALUES (26,'PR28');
INSERT INTO QTAB VALUES (28,'A11');
INSERT INTO QTAB VALUES (29,'PR3-a');
INSERT INTO QTAB VALUES (30,'PR3-a');
INSERT INTO QTAB VALUES (30,'PR3-b');
INSERT INTO QTAB VALUES (31,'PR37-a');
INSERT INTO QTAB VALUES (32,'PR37-a');
INSERT INTO QTAB VALUES (32,'PR37-b');
INSERT INTO QTAB VALUES (34,'1');
INSERT INTO QTAB VALUES (35,'PR39');
INSERT INTO QTAB VALUES (36,'3');
INSERT INTO QTAB VALUES (37,'4');
INSERT INTO QTAB VALUES (38,'2');
INSERT INTO QTAB VALUES (39,'PR12');
INSERT INTO QTAB VALUES (40,'PR38');
INSERT INTO QTAB VALUES (41,'PR29');
INSERT INTO QTAB VALUES (43,'PR34');
INSERT INTO QTAB VALUES (44,'PR41');
INSERT INTO QTAB VALUES (46,'A9');
INSERT INTO QTAB VALUES (47,'PR10');
INSERT INTO QTAB VALUES (48,'A8');
INSERT INTO QTAB VALUES (50,'A5');
INSERT INTO QTAB VALUES (50,'A6');
INSERT INTO QTAB VALUES (51,'A4');
INSERT INTO QTAB VALUES (52,'A7-a');
INSERT INTO QTAB VALUES (53,'PR28');
INSERT INTO QTAB VALUES (55,'A3-a');
INSERT INTO QTAB VALUES (56,'A3-a');
INSERT INTO QTAB VALUES (57,'A14');
INSERT INTO QTAB VALUES (58,'PR1');
INSERT INTO QTAB VALUES (59,'PR2');
INSERT INTO QTAB VALUES (60,'PR5');
INSERT INTO QTAB VALUES (61,'PR6');
INSERT INTO QTAB VALUES (63,'PR9A-2');
INSERT INTO QTAB VALUES (64,'PR9B');
INSERT INTO QTAB VALUES (65,'PR8');
INSERT INTO QTAB VALUES (66,'PR11');
INSERT INTO QTAB VALUES (68,'PR31');
INSERT INTO QTAB VALUES (68,'PR32');
INSERT INTO QTAB VALUES (69,'PR31');
INSERT INTO QTAB VALUES (69,'PR32');
INSERT INTO QTAB VALUES (73,'A1-a');
INSERT INTO QTAB VALUES (74,'A1-b');
INSERT INTO QTAB VALUES (75,'PR4');
INSERT INTO QTAB VALUES (76,'PR7');
INSERT INTO QTAB VALUES (77,'PR9A-2');
INSERT INTO QTAB VALUES (78,'PR33');
INSERT INTO QTAB VALUES (79,'PR13');
INSERT INTO QTAB VALUES (81,'PR40');
INSERT INTO QTAB VALUES (82,'PR43');
INSERT INTO QTAB VALUES (83,'PR33');
INSERT INTO QTAB VALUES (84,'PR42');

[talder]

Apologies for all the annoyingly long posts. Just wanted to make sure I provided all the SQL statements so they are available for any kind soul that wishes to try them out.