home *** CD-ROM | disk | FTP | other *** search

---

/ Piper's Pit BBS/FTP: ibm 0040 - 0049 / ibm0040-0049 / ibm0040.tar / ibm0040 / WINBASE2.ZIP / EXAMPLES.EXE / DEMO / DEMO.SQL

< prev

next >

Wrap

Comma Seperated Value File  |  1991-07-16  |  14.9 KB  |  316 rows

---

#	CREATE TABLE APT3(MO INT	DA INT	TI CHAR(21)	CLIENT CHAR(20)	MECHANIC CHAR(20)	JOB CHAR(20));
1	INSERT INTO APT3(MO	DA	TI	CLIENT	MECHANIC	JOB)
2	VALUES(0	0	'01/01/91 12:00:00 AM'	'Penny'	''	'');
3	INSERT INTO APT3(MO	DA	TI	CLIENT	MECHANIC	JOB)
4	VALUES(1	1	'01/01/91 12:00:00 AM'	'Allan Blake'	'Tom'	'Front End Alingment');
5	INSERT INTO APT3(MO	DA	TI	CLIENT	MECHANIC	JOB)
6	VALUES(1	1	'01/01/91 12:00:00 AM'	'Peg Gray'	'Joe'	'Brake Inspection');
7	INSERT INTO APT3(MO	DA	TI	CLIENT	MECHANIC	JOB)
8	VALUES(1	2	'01/01/91 12:00:00 AM'	'Willard Rother'	'Tom'	'Brake Inspection');
9	INSERT INTO APT3(MO	DA	TI	CLIENT	MECHANIC	JOB)
10	VALUES(1	1	'01/01/91 12:00:00 AM'	'Megan Jones'	'Ed'	'Tune Up');
11	INSERT INTO APT3(MO	DA	TI	CLIENT	MECHANIC	JOB)
12	VALUES(1	2	'01/01/91 12:00:00 AM'	'Elizabeth Doyle'	'Joe'	'Oil Change');
13	CREATE TABLE INVENTY(PART_NUM CHAR(9)	PROD_NAME CHAR(9)	PROD_DESC CHAR(14)	U_PRICE MONEY	U_COST MONEY
14	FULL_DESC CHAR(40)	INVENTORY INT);
15	INSERT INTO INVENTY(PART_NUM	PROD_NAME	PROD_DESC	U_PRICE	U_COST	FULL_DESC	INVENTORY)
16	VALUES('E-34798'	'Ford'	'Water pump'	89.9900	50.0000	''	30);
17	INSERT INTO INVENTY(PART_NUM	PROD_NAME	PROD_DESC	U_PRICE	U_COST	FULL_DESC	INVENTORY)
18	VALUES('B-91326'	'Acmar'	'Fender'	125.0000	75.0000	''	3);
19	INSERT INTO INVENTY(PART_NUM	PROD_NAME	PROD_DESC	U_PRICE	U_COST	FULL_DESC	INVENTORY)
20	VALUES('M-65390'	'Glade'	'Air Freshner'	3.9900	1.7500	''	100);
21	CREATE TABLE SALES(SALESPERSON CHAR(14)	PRODUCT CHAR(13)	QTY INT	PRICE MONEY
22	SALEAMT MONEY	COMMISSIONS MONEY);
23	INSERT INTO SALES(SALESPERSON	PRODUCT	QTY	PRICE	SALEAMT	COMMISSIONS)
24	VALUES('John Green'	'Ming Vase'	2	2100.0000	4200.0000	840.0000);
25	INSERT INTO SALES(SALESPERSON	PRODUCT	QTY	PRICE	SALEAMT	COMMISSIONS)
26	VALUES('Hank Gibson'	'Large Rug'	1	800.0000	800.0000	160.0000);
27	INSERT INTO SALES(SALESPERSON	PRODUCT	QTY	PRICE	SALEAMT	COMMISSIONS)
28	VALUES('Harry Harris'	'Paper Fan'	100	1.2900	129.0000	25.8000);
29	INSERT INTO SALES(SALESPERSON	PRODUCT	QTY	PRICE	SALEAMT	COMMISSIONS)
30	VALUES('Jeff Ericson'	'Small Rug'	2	1600.0000	3200.0000	640.0000);
31	INSERT INTO SALES(SALESPERSON	PRODUCT	QTY	PRICE	SALEAMT	COMMISSIONS)
32	VALUES('John Green'	'Oil Lamp'	27	147.0000	3969.0000	793.8000);
33	INSERT INTO SALES(SALESPERSON	PRODUCT	QTY	PRICE	SALEAMT	COMMISSIONS)
34	VALUES('Peggy Sue'	'Onyx Ring'	10	2000.0000	20000.0000	4000.0000);
35	INSERT INTO SALES(SALESPERSON	PRODUCT	QTY	PRICE	SALEAMT	COMMISSIONS)
36	VALUES('Jeff Ericson'	'Medium Rug'	5	500.0000	2500.0000	500.0000);
37	INSERT INTO SALES(SALESPERSON	PRODUCT	QTY	PRICE	SALEAMT	COMMISSIONS)
38	VALUES('Molly Brown'	'Chinese Firew'	35	4.7900	167.6500	33.5300);
39	INSERT INTO SALES(SALESPERSON	PRODUCT	QTY	PRICE	SALEAMT	COMMISSIONS)
40	VALUES('Molly Brown'	'Ming Vase'	2	1350.0000	2700.0000	540.0000);
41	INSERT INTO SALES(SALESPERSON	PRODUCT	QTY	PRICE	SALEAMT	COMMISSIONS)
42	VALUES('Wilma Stone'	'Ming Vase'	1	1900.0000	1900.0000	380.0000);
43	INSERT INTO SALES(SALESPERSON	PRODUCT	QTY	PRICE	SALEAMT	COMMISSIONS)
44	VALUES('James Bean'	'Carved Dog'	6	250.0000	1500.0000	300.0000);
45	INSERT INTO SALES(SALESPERSON	PRODUCT	QTY	PRICE	SALEAMT	COMMISSIONS)
46	VALUES('Adam Baum'	'Large Rug'	10	500.0000	5000.0000	1000.0000);
47	INSERT INTO SALES(SALESPERSON	PRODUCT	QTY	PRICE	SALEAMT	COMMISSIONS)
48	VALUES('Hank Gibson'	'Rug	Bahktiar'	4	500.0000	2000.0000	400.0000);
49	INSERT INTO SALES(SALESPERSON	PRODUCT	QTY	PRICE	SALEAMT	COMMISSIONS)
50	VALUES('Hank Gibson'	'Vase	Ming'	1	2200.0000	2200.0000	440.0000);
51	INSERT INTO SALES(SALESPERSON	PRODUCT	QTY	PRICE	SALEAMT	COMMISSIONS)
52	VALUES('Hank Gibson'	'Desk	Orienta'	1	3500.0000	3500.0000	700.0000);
53	INSERT INTO SALES(SALESPERSON	PRODUCT	QTY	PRICE	SALEAMT	COMMISSIONS)
54	VALUES('Hank Gibson'	'Table'	2	1450.0000	2900.0000	580.0000);
55	INSERT INTO SALES(SALESPERSON	PRODUCT	QTY	PRICE	SALEAMT	COMMISSIONS)
56	VALUES('Harrald Jens'	'Table'	4	2500.0000	10000.0000	2000.0000);
57	CREATE TABLE SALESMAN(NAME CHAR(14)	BRANCH CHAR(15)	TOTALSALES MONEY
58	COMMISION MONEY	BONUS CHAR(4));
59	INSERT INTO SALESMAN(NAME	BRANCH	TOTALSALES	COMMISION	BONUS)
60	VALUES('John Green'	'Los Angeles'	8169.0000	1633.8000	'');
61	INSERT INTO SALESMAN(NAME	BRANCH	TOTALSALES	COMMISION	BONUS)
62	VALUES('Hank Gibson'	'New York'	11400.0000	2280.0000	'');
63	INSERT INTO SALESMAN(NAME	BRANCH	TOTALSALES	COMMISION	BONUS)
64	VALUES('Molly Brown'	'London'	2867.6500	573.5300	'');
65	INSERT INTO SALESMAN(NAME	BRANCH	TOTALSALES	COMMISION	BONUS)
66	VALUES('James Bean'	'Paris'	1500.0000	300.0000	'');
67	INSERT INTO SALESMAN(NAME	BRANCH	TOTALSALES	COMMISION	BONUS)
68	VALUES('Wilma Stone'	'Madrid'	1900.0000	380.0000	'');
69	INSERT INTO SALESMAN(NAME	BRANCH	TOTALSALES	COMMISION	BONUS)
70	VALUES('Jeff Ericson'	'Sydney'	5700.0000	1140.0000	'');
71	INSERT INTO SALESMAN(NAME	BRANCH	TOTALSALES	COMMISION	BONUS)
72	VALUES('Harrald Jens'	'Frankfurt'	10000.0000	2000.0000	'');
73	INSERT INTO SALESMAN(NAME	BRANCH	TOTALSALES	COMMISION	BONUS)
74	VALUES('Harry Harris'	'Midwest'	2889.0000	577.8000	'');
75	INSERT INTO SALESMAN(NAME	BRANCH	TOTALSALES	COMMISION	BONUS)
76	VALUES('Peggy Sue'	'Texas'	20000.0000	4000.0000	'');
77	CREATE TABLE PROD(PRODNO INT	LISTPRICE MONEY	DESCRIP CHAR(30));
78	INSERT INTO PROD(PRODNO	LISTPRICE	DESCRIP)
79	VALUES(95	6.1900	'Loovenbroy Beer');
80	INSERT INTO PROD(PRODNO	LISTPRICE	DESCRIP)
81	VALUES(99	18.3500	'Chair');
82	INSERT INTO PROD(PRODNO	LISTPRICE	DESCRIP)
83	VALUES(107	32.9300	'Reading Lamp');
84	INSERT INTO PROD(PRODNO	LISTPRICE	DESCRIP)
85	VALUES(123	3.8600	'Beer Mugs');
86	INSERT INTO PROD(PRODNO	LISTPRICE	DESCRIP)
87	VALUES(215	0.3300	'Black Pens');
88	INSERT INTO PROD(PRODNO	LISTPRICE	DESCRIP)
89	VALUES(300	40.1000	'Bar Stools');
90	INSERT INTO PROD(PRODNO	LISTPRICE	DESCRIP)
91	VALUES(334	46.6200	'Desktop Calculator');
92	INSERT INTO PROD(PRODNO	LISTPRICE	DESCRIP)
93	VALUES(444	59.6600	'Plant Stand');
94	INSERT INTO PROD(PRODNO	LISTPRICE	DESCRIP)
95	VALUES(445	311.5900	'Down Parka');
96	INSERT INTO PROD(PRODNO	LISTPRICE	DESCRIP)
97	VALUES(458	717.4400	'Camper Shell');
98	INSERT INTO PROD(PRODNO	LISTPRICE	DESCRIP)
99	VALUES(600	176587.9500	'Oil Rig');
100	INSERT INTO PROD(PRODNO	LISTPRICE	DESCRIP)
101	VALUES(601	35874.0800	'Computer');
102	INSERT INTO PROD(PRODNO	LISTPRICE	DESCRIP)
103	VALUES(602	1722.6900	'Printer');
104	INSERT INTO PROD(PRODNO	LISTPRICE	DESCRIP)
105	VALUES(603	256.4000	'Cables');
106	INSERT INTO PROD(PRODNO	LISTPRICE	DESCRIP)
107	VALUES(608	4.5100	'Real (TM) Coffee');
108	INSERT INTO PROD(PRODNO	LISTPRICE	DESCRIP)
109	VALUES(690	74.0400	'Room Dividers');
110	INSERT INTO PROD(PRODNO	LISTPRICE	DESCRIP)
111	VALUES(700	168.2200	'Esspresso Machine');
112	INSERT INTO PROD(PRODNO	LISTPRICE	DESCRIP)
113	VALUES(750	7.6200	'Parchment');
114	INSERT INTO PROD(PRODNO	LISTPRICE	DESCRIP)
115	VALUES(755	7306.3800	'Tractor');
116	INSERT INTO PROD(PRODNO	LISTPRICE	DESCRIP)
117	VALUES(780	50000.0000	'Bulldozer');
118	INSERT INTO PROD(PRODNO	LISTPRICE	DESCRIP)
119	VALUES(800	1875.0000	'Laser Printer');
120	INSERT INTO PROD(PRODNO	LISTPRICE	DESCRIP)
121	VALUES(801	98.0000	'Toner Cartridge');
122	INSERT INTO PROD(PRODNO	LISTPRICE	DESCRIP)
123	VALUES(805	4500.0000	'VGA Monitor');
124	INSERT INTO PROD(PRODNO	LISTPRICE	DESCRIP)
125	VALUES(810	3500.0000	'386-25 Computer');
126	INSERT INTO PROD(PRODNO	LISTPRICE	DESCRIP)
127	VALUES(820	4500.0000	'386-33 Computer');
128	CREATE TABLE CUST(CUSTNO INT	NAME CHAR(16)	ADDRESS CHAR(22)	CITY CHAR(13)	STATE CHAR(6)
129	ZIP INT	PREVBAL MONEY	PREVBALDATE CHAR(21));
130	INSERT INTO CUST(CUSTNO	NAME	ADDRESS	CITY	STATE	ZIP	PREVBAL	PREVBALDATE)
131	VALUES(10	'AA Aerospace'	'1010 Columbia Ave.'	'San Diego'	'CA'	921212723	8258.7700	'01-01-91 12:00:00 AM');
132	INSERT INTO CUST(CUSTNO	NAME	ADDRESS	CITY	STATE	ZIP	PREVBAL	PREVBALDATE)
133	VALUES(20	'Associated Steel'	'1445 Industry Rd.'	'Chicago'	'Ill'	549022343	723.1800	'01-01-91 12:00:00 AM');
134	INSERT INTO CUST(CUSTNO	NAME	ADDRESS	CITY	STATE	ZIP	PREVBAL	PREVBALDATE)
135	VALUES(30	'Barrys Bar'	'823 Munich St.'	'Milwaukee'	'Wis'	300232843	10.0000	'01-01-91 12:00:00 AM');
136	INSERT INTO CUST(CUSTNO	NAME	ADDRESS	CITY	STATE	ZIP	PREVBAL	PREVBALDATE)
137	VALUES(40	'Digital Designs'	'6364 Complex Dr.'	'Los Angeles'	'CA'	933249481	100.0000	'01-01-91 12:00:00 AM');
138	INSERT INTO CUST(CUSTNO	NAME	ADDRESS	CITY	STATE	ZIP	PREVBAL	PREVBALDATE)
139	VALUES(50	'Farkel Fur Farm'	'156 Beaver Ln.'	'Buford'	'Main'	2340002	100.0000	'01-01-91 12:00:00 AM');
140	INSERT INTO CUST(CUSTNO	NAME	ADDRESS	CITY	STATE	ZIP	PREVBAL	PREVBALDATE)
141	VALUES(60	'Freds Farm Machi'	'255 Maple St.'	'Farmington'	'NM'	889234323	100.0000	'01-01-91 12:00:00 AM');
142	INSERT INTO CUST(CUSTNO	NAME	ADDRESS	CITY	STATE	ZIP	PREVBAL	PREVBALDATE)
143	VALUES(70	'Joes Camper Sale'	'724 Butte Ave.'	'Missoula'	'MT'	570072365	100.0000	'01-01-91 12:00:00 AM');
144	INSERT INTO CUST(CUSTNO	NAME	ADDRESS	CITY	STATE	ZIP	PREVBAL	PREVBALDATE)
145	VALUES(80	'Paper Emporium'	'898 W. Constitution St'	'Hartford'	'Conn'	61066467	100.0000	'01-01-91 12:00:00 AM');
146	INSERT INTO CUST(CUSTNO	NAME	ADDRESS	CITY	STATE	ZIP	PREVBAL	PREVBALDATE)
147	VALUES(90	'Penguin Polaris'	'823 Byrd Ave'	'Fairbanks'	'AK'	993435267	100.0000	'01-01-91 12:00:00 AM');
148	INSERT INTO CUST(CUSTNO	NAME	ADDRESS	CITY	STATE	ZIP	PREVBAL	PREVBALDATE)
149	VALUES(100	'Silicon Products'	'123 So. Ruffin Rd.'	'San Diego'	'CA'	921234562	100.0000	'01-01-91 12:00:00 AM');
150	CREATE TABLE DUMMY(DUMMYCOL CHAR(10));
151	INSERT INTO DUMMY(DUMMYCOL)
152	VALUES('dummy');
153	CREATE TABLE DAYS(DAY INT);
154	INSERT INTO DAYS(DAY)
155	VALUES(1);
156	INSERT INTO DAYS(DAY)
157	VALUES(2);
158	INSERT INTO DAYS(DAY)
159	VALUES(3);
160	INSERT INTO DAYS(DAY)
161	VALUES(4);
162	INSERT INTO DAYS(DAY)
163	VALUES(5);
164	INSERT INTO DAYS(DAY)
165	VALUES(6);
166	INSERT INTO DAYS(DAY)
167	VALUES(7);
168	INSERT INTO DAYS(DAY)
169	VALUES(8);
170	INSERT INTO DAYS(DAY)
171	VALUES(9);
172	INSERT INTO DAYS(DAY)
173	VALUES(10);
174	INSERT INTO DAYS(DAY)
175	VALUES(11);
176	INSERT INTO DAYS(DAY)
177	VALUES(12);
178	INSERT INTO DAYS(DAY)
179	VALUES(13);
180	INSERT INTO DAYS(DAY)
181	VALUES(14);
182	INSERT INTO DAYS(DAY)
183	VALUES(15);
184	INSERT INTO DAYS(DAY)
185	VALUES(16);
186	INSERT INTO DAYS(DAY)
187	VALUES(17);
188	INSERT INTO DAYS(DAY)
189	VALUES(18);
190	INSERT INTO DAYS(DAY)
191	VALUES(19);
192	INSERT INTO DAYS(DAY)
193	VALUES(20);
194	INSERT INTO DAYS(DAY)
195	VALUES(21);
196	INSERT INTO DAYS(DAY)
197	VALUES(22);
198	INSERT INTO DAYS(DAY)
199	VALUES(23);
200	INSERT INTO DAYS(DAY)
201	VALUES(24);
202	INSERT INTO DAYS(DAY)
203	VALUES(25);
204	INSERT INTO DAYS(DAY)
205	VALUES(26);
206	INSERT INTO DAYS(DAY)
207	VALUES(27);
208	INSERT INTO DAYS(DAY)
209	VALUES(28);
210	INSERT INTO DAYS(DAY)
211	VALUES(29);
212	INSERT INTO DAYS(DAY)
213	VALUES(30);
214	INSERT INTO DAYS(DAY)
215	VALUES(31);
216	CREATE TABLE LINE(PNO INT	PRICE MONEY	QTY INT	AMT MONEY	ONO CHAR(20));
217	INSERT INTO LINE(PNO	PRICE	QTY	AMT	ONO)
218	VALUES(601	27500.0000	2	55000.0000	'BLK-031290-1');
219	INSERT INTO LINE(PNO	PRICE	QTY	AMT	ONO)
220	VALUES(602	1320.6700	1	1320.6700	'BLK-031290-1');
221	INSERT INTO LINE(PNO	PRICE	QTY	AMT	ONO)
222	VALUES(603	3.3000	4	13.2000	'BLK-031290-1');
223	INSERT INTO LINE(PNO	PRICE	QTY	AMT	ONO)
224	VALUES(755	5600.9500	1	5600.9500	'BLK-031290-2');
225	INSERT INTO LINE(PNO	PRICE	QTY	AMT	ONO)
226	VALUES(123	3.0000	100	300.0000	'BLK-031290-3');
227	INSERT INTO LINE(PNO	PRICE	QTY	AMT	ONO)
228	VALUES(300	30.8500	5	154.2500	'BLK-031290-3');
229	INSERT INTO LINE(PNO	PRICE	QTY	AMT	ONO)
230	VALUES(700	129.0000	1	129.0000	'BLK-031290-3');
231	INSERT INTO LINE(PNO	PRICE	QTY	AMT	ONO)
232	VALUES(99	14.1800	10	141.8000	'BLK-031290-3');
233	INSERT INTO LINE(PNO	PRICE	QTY	AMT	ONO)
234	VALUES(107	25.3900	1	25.3900	'BLK-031290-3');
235	INSERT INTO LINE(PNO	PRICE	QTY	AMT	ONO)
236	VALUES(334	35.8500	20	717.0000	'BLK-031290-5');
237	INSERT INTO LINE(PNO	PRICE	QTY	AMT	ONO)
238	VALUES(99	14.1800	5	70.9000	'BLK-031290-5');
239	INSERT INTO LINE(PNO	PRICE	QTY	AMT	ONO)
240	VALUES(690	56.8500	20	1137.0000	'BLK-031290-6');
241	INSERT INTO LINE(PNO	PRICE	QTY	AMT	ONO)
242	VALUES(107	25.3900	10	253.9000	'BLK-031290-7');
243	INSERT INTO LINE(PNO	PRICE	QTY	AMT	ONO)
244	VALUES(215	0.3100	3	0.9300	'BLK-031290-2');
245	INSERT INTO LINE(PNO	PRICE	QTY	AMT	ONO)
246	VALUES(445	238.9500	12	2867.4000	'BLK-031290-2');
247	INSERT INTO LINE(PNO	PRICE	QTY	AMT	ONO)
248	VALUES(600	135367.0000	1	135367.0000	'BLK-070191-11');
249	INSERT INTO LINE(PNO	PRICE	QTY	AMT	ONO)
250	VALUES(334	46.6200	60	2797.2000	'BLK-070391-12');
251	CREATE TABLE INITIALS(INITIALS CHAR(3));
252	INSERT INTO INITIALS(INITIALS)
253	VALUES('BLK');
254	INSERT INTO INITIALS(INITIALS)
255	VALUES('LKH');
256	INSERT INTO INITIALS(INITIALS)
257	VALUES('CLS');
258	INSERT INTO INITIALS(INITIALS)
259	VALUES('GMC');
260	CREATE TABLE MONTHS(MONTH INT	MAXDAYS INT);
261	INSERT INTO MONTHS(MONTH	MAXDAYS)
262	VALUES(1	31);
263	INSERT INTO MONTHS(MONTH	MAXDAYS)
264	VALUES(2	28);
265	INSERT INTO MONTHS(MONTH	MAXDAYS)
266	VALUES(3	31);
267	INSERT INTO MONTHS(MONTH	MAXDAYS)
268	VALUES(4	30);
269	INSERT INTO MONTHS(MONTH	MAXDAYS)
270	VALUES(5	31);
271	INSERT INTO MONTHS(MONTH	MAXDAYS)
272	VALUES(6	30);
273	INSERT INTO MONTHS(MONTH	MAXDAYS)
274	VALUES(7	31);
275	INSERT INTO MONTHS(MONTH	MAXDAYS)
276	VALUES(8	31);
277	INSERT INTO MONTHS(MONTH	MAXDAYS)
278	VALUES(9	30);
279	INSERT INTO MONTHS(MONTH	MAXDAYS)
280	VALUES(10	31);
281	INSERT INTO MONTHS(MONTH	MAXDAYS)
282	VALUES(11	30);
283	INSERT INTO MONTHS(MONTH	MAXDAYS)
284	VALUES(12	31);
285	CREATE TABLE MECHANIC(MECHANIC CHAR(20)	WAGE MONEY	SPECIALITY CHAR(20));
286	INSERT INTO MECHANIC(MECHANIC	WAGE	SPECIALITY)
287	VALUES('Joe'	11.5000	'Brakes');
288	INSERT INTO MECHANIC(MECHANIC	WAGE	SPECIALITY)
289	VALUES('Tom'	12.7500	'Engine work');
290	INSERT INTO MECHANIC(MECHANIC	WAGE	SPECIALITY)
291	VALUES('Ed'	10.0000	'General');
292	CREATE TABLE TRANSACT(TRANSDATE CHAR(21)	CNO INT	TRANSAMT MONEY	SHIPDATE CHAR(21)
293	TRANSNO CHAR(16)	ENTERBY CHAR(7)	TRANSTYPE CHAR(9));
294	INSERT INTO TRANSACT(TRANSDATE	CNO	TRANSAMT	SHIPDATE	TRANSNO	ENTERBY	TRANSTYPE)
295	VALUES('01-01-91 12:00:00 AM'	10	56333.8700	'01-01-91 12:00:00 AM'	'BLK-031290-1'	'BLK'	'ORDER');
296	INSERT INTO TRANSACT(TRANSDATE	CNO	TRANSAMT	SHIPDATE	TRANSNO	ENTERBY	TRANSTYPE)
297	VALUES('01-01-91 12:00:00 AM'	20	8469.2800	'01-01-91 12:00:00 AM'	'BLK-031290-2'	'BLK'	'ORDER');
298	INSERT INTO TRANSACT(TRANSDATE	CNO	TRANSAMT	SHIPDATE	TRANSNO	ENTERBY	TRANSTYPE)
299	VALUES('01-01-91 12:00:00 AM'	30	750.4400	'01-01-91 12:00:00 AM'	'BLK-031290-3'	'BLK'	'ORDER');
300	INSERT INTO TRANSACT(TRANSDATE	CNO	TRANSAMT	SHIPDATE	TRANSNO	ENTERBY	TRANSTYPE)
301	VALUES('01-01-91 12:00:00 AM'	10	10000.0000	'01-01-91 12:00:00 AM'	'BLK-031290-4'	'BLK'	'PAYMENT');
302	INSERT INTO TRANSACT(TRANSDATE	CNO	TRANSAMT	SHIPDATE	TRANSNO	ENTERBY	TRANSTYPE)
303	VALUES('01-01-91 12:00:00 AM'	10	787.9000	'01-01-91 12:00:00 AM'	'BLK-031290-5'	'BLK'	'ORDER');
304	INSERT INTO TRANSACT(TRANSDATE	CNO	TRANSAMT	SHIPDATE	TRANSNO	ENTERBY	TRANSTYPE)
305	VALUES('01-01-91 12:00:00 AM'	10	1137.0000	'01-01-91 12:00:00 AM'	'BLK-031290-6'	'BLK'	'ORDER');
306	INSERT INTO TRANSACT(TRANSDATE	CNO	TRANSAMT	SHIPDATE	TRANSNO	ENTERBY	TRANSTYPE)
307	VALUES('01-01-91 12:00:00 AM'	20	253.9000	'01-01-91 12:00:00 AM'	'BLK-031290-7'	'BLK'	'ORDER');
308	INSERT INTO TRANSACT(TRANSDATE	CNO	TRANSAMT	SHIPDATE	TRANSNO	ENTERBY	TRANSTYPE)
309	VALUES('01-01-91 12:00:00 AM'	10	40000.0000	'01-01-91 12:00:00 AM'	'BLK-031290-8'	'BLK'	'PAYMENT');
310	INSERT INTO TRANSACT(TRANSDATE	CNO	TRANSAMT	SHIPDATE	TRANSNO	ENTERBY	TRANSTYPE)
311	VALUES('01-01-91 12:00:00 AM'	20	8000.0000	'01-01-91 12:00:00 AM'	'BLK-031290-9'	'BLK'	'PAYMENT');
312	INSERT INTO TRANSACT(TRANSDATE	CNO	TRANSAMT	SHIPDATE	TRANSNO	ENTERBY	TRANSTYPE)
313	VALUES('01-01-91 12:00:00 AM'	30	750.4400	'01-01-91 12:00:00 AM'	'BLK-050490-1'	'BLK'	'PAYMENT');
314	INSERT INTO TRANSACT(TRANSDATE	CNO	TRANSAMT	SHIPDATE	TRANSNO	ENTERBY	TRANSTYPE)
315	VALUES('07-01-91 12:00:00 AM'	10	135367.0000	'01-01-91 12:00:00 AM'	'BLK-070191-11'	'BLK'	'ORDER');