-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathLoad_transactionItem.sql
40 lines (40 loc) · 1.71 KB
/
Load_transactionItem.sql
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
/*insert into TransactionItem (itemID,transactionID,price)
values (000,00,00.00);*/
insert into TransactionItem (itemID,transactionID,SoldPrice)
values (001,01,15.99);
insert into TransactionItem (itemID,transactionID,SoldPrice)
values (008,01,33.65);
insert into TransactionItem (itemID,transactionID,SoldPrice)
values (015,01,8.49);
insert into TransactionItem (itemID,transactionID,SoldPrice)
values (011,01,0.99);
insert into TransactionItem (itemID,transactionID,SoldPrice)
values (012,02,0.99);
insert into TransactionItem (itemID,transactionID,SoldPrice)
values (022,03,12.75);
insert into TransactionItem (itemID,transactionID,SoldPrice)
values (023,03,11.25);
insert into TransactionItem (itemID,transactionID,SoldPrice)
values (005,03,39.59);
insert into TransactionItem (itemID,transactionID,SoldPrice)
values (001,04,15.99);
insert into TransactionItem (itemID,transactionID,SoldPrice)
values (009,04,19.18);
insert into TransactionItem (itemID,transactionID,SoldPrice)
values (017,05,1.50);
insert into TransactionItem (itemID,transactionID,SoldPrice)
values (011,06,0.99);
insert into TransactionItem (itemID,transactionID,SoldPrice)
values (020,06,1.25);
insert into TransactionItem (itemID,transactionID,SoldPrice)
values (003,07,16.99);
insert into TransactionItem (itemID,transactionID,SoldPrice)
values (010,07,39.64);
insert into TransactionItem (itemID,transactionID,SoldPrice)
values (009,07,19.18);
insert into TransactionItem (itemID,transactionID,SoldPrice)
values (004,07,9.99);
insert into TransactionItem (itemID,transactionID,SoldPrice)
values (014,07,29.00);
insert into TransactionItem (itemID,transactionID,SoldPrice)
values (021,07,12.75);