SHARE
TWEET

Untitled

a guest Feb 19th, 2019 73 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. USE HSD
  2. GO
  3.  
  4. /*****   CUSTOMER DATA   ********************************************************/
  5.  
  6. INSERT INTO CUSTOMER VALUES(
  7.     'Jacobs', 'Nancy', 'Nancy.Jacobs@somewhere.com', 'nf46tG9E', '817-871-8123',
  8.     '1440 West Palm Drive', 'Fort Worth', 'TX', '76110');
  9. INSERT INTO CUSTOMER VALUES(
  10.     'Jacobs', 'Chantel', 'Chantel.Jacobs@somewhere.com', 'b65TG03f', '817-871-8234',
  11.     '1550 East Palm Drive', 'Fort Worth', 'TX', '76112');
  12. INSERT INTO CUSTOMER VALUES(
  13.     'Able', 'Ralph', 'Ralph.Able@somewhere.com', 'm56fGH08', '210-281-7987',
  14.     '123 Elm Street', 'San Antonio', 'TX', '78214');
  15. INSERT INTO CUSTOMER VALUES(
  16.     'Baker', 'Susan', 'Susan.Baker@elsewhere.com', 'PC93fEk9', '210-281-7876',
  17.     '456 Oak Street', 'San Antonio', 'TX', '78216');
  18. INSERT INTO CUSTOMER VALUES(
  19.     'Eagleton', 'Sam', 'Sam.Eagleton@elsewhere.com', 'bnvR44W8', '210-281-7765',
  20.     '789 Pine Street', 'San Antonio', 'TX', '78218');
  21. INSERT INTO CUSTOMER VALUES(
  22.     'Foxtrot', 'Kathy', 'Kathy.Foxtrot@somewhere.com', 'aa8tY4GL', '972-233-6234',
  23.     '11023 Elm Street', 'Dallas', 'TX', '75220');
  24. INSERT INTO CUSTOMER VALUES(
  25.     'George', 'Sally', 'Sally.George@somewhere.com', 'LK8G2tyF', '972-233-6345',
  26.     '12034 San Jacinto', 'Dallas', 'TX', '75223');
  27. INSERT INTO CUSTOMER VALUES(
  28.     'Hullett', 'Shawn', 'Shawn.Hullett@elsewhere.com', 'bu78WW3t', '972-233-6456',
  29.     '13045 Flora', 'Dallas', 'TX', '75224');
  30. INSERT INTO CUSTOMER VALUES(
  31.     'Pearson', 'Bobbi', 'Bobbi.Pearson@elsewhere.com', 'kq6N2O0p', '512-974-3344',
  32.     '43 West 23rd Street', 'Austin', 'TX', '78710');
  33. INSERT INTO CUSTOMER VALUES(
  34.     'Ranger', 'Terry', 'Terry.Ranger@somewhere.com', 'bv3F9Qc4', '512-974-4455',
  35.     '56 East 18th Street', 'Austin', 'TX', '78712');
  36. INSERT INTO CUSTOMER VALUES(
  37.     'Tyler', 'Jenny', 'Jenny.Tyler@somewhere.com', 'Yu4be77Z', '972-233-6567',
  38.     '14056 South Ervay Street', 'Dallas', 'TX', '75225');
  39. INSERT INTO CUSTOMER VALUES(
  40.     'Wayne', 'Joan', 'Joan.Wayne@elsewhere.com', 'JW4TX6g', '817-871-8245',
  41.     '1660 South Aspen Drive', 'Fort Worth', 'TX', '76115');
  42.  
  43.  
  44. /*****   SEMINAR   **************************************************************/
  45.  
  46. INSERT INTO SEMINAR VALUES(
  47.     '12-OCT-2016', '11:00 AM', 'San Antonio Convention Center',
  48.     'Kitchen on a Budget');
  49. INSERT INTO SEMINAR VALUES(
  50.     '26-OCT-2016', '04:00 PM', 'Dallas Convention Center',
  51.     'Kitchen on a Big D Budget');
  52. INSERT INTO SEMINAR VALUES(
  53.     '02-NOV-2016', '08:30 AM', 'Austin Convention Center',
  54.     'Kitchen on a Budget');
  55. INSERT INTO SEMINAR VALUES(
  56.     '22-MAR-2017', '11:00 AM', 'Dallas Convention Center',
  57.     'Kitchen on a Big D Budget');
  58. INSERT INTO SEMINAR VALUES(
  59.     '23-MAR-2017', '11:00 AM', 'Dallas Convention Center',
  60.     'Kitchen on a Big D Budget');
  61. INSERT INTO SEMINAR VALUES(
  62.     '05-APR-2017', '08:30 AM', 'Austin Convention Center',
  63.     'Kitchen on a Budget');
  64.  
  65.  
  66. /*****   SEMINAR_CUSTOMER DATA   ************************************************/
  67.  
  68. INSERT INTO SEMINAR_CUSTOMER VALUES(1, 1);
  69. INSERT INTO SEMINAR_CUSTOMER VALUES(1, 2);
  70. INSERT INTO SEMINAR_CUSTOMER VALUES(1, 3);
  71. INSERT INTO SEMINAR_CUSTOMER VALUES(1, 4);
  72. INSERT INTO SEMINAR_CUSTOMER VALUES(1, 5);
  73. INSERT INTO SEMINAR_CUSTOMER VALUES(2, 6);
  74. INSERT INTO SEMINAR_CUSTOMER VALUES(2, 7);
  75. INSERT INTO SEMINAR_CUSTOMER VALUES(2, 8);
  76. INSERT INTO SEMINAR_CUSTOMER VALUES(3, 9);
  77. INSERT INTO SEMINAR_CUSTOMER VALUES(3, 10);
  78. INSERT INTO SEMINAR_CUSTOMER VALUES(4, 6);
  79. INSERT INTO SEMINAR_CUSTOMER VALUES(4, 7);
  80. INSERT INTO SEMINAR_CUSTOMER VALUES(4, 11);
  81. INSERT INTO SEMINAR_CUSTOMER VALUES(4, 12);
  82.  
  83.  
  84. /*****   CONTACT DATA   *********************************************************/
  85.  
  86. -- 'Nancy.Jacobs@somewhere.com'
  87. INSERT INTO CONTACT VALUES(1, 1, '12-OCT-2016', 'Seminar', 1);
  88. -- 'Chantel.Jacobs@somewhere.com'
  89. INSERT INTO CONTACT VALUES(2, 1, '12-OCT-2016', 'Seminar', 1);
  90. -- 'Ralph.Able@somewhere.com'
  91. INSERT INTO CONTACT VALUES(3, 1, '12-OCT-2016', 'Seminar', 1);
  92. -- 'Susan.Baker@elsewhere.com'
  93. INSERT INTO CONTACT VALUES(4, 1, '12-OCT-2016', 'Seminar', 1);
  94. -- 'Sam.Eagleton@elsewhere.com'
  95. INSERT INTO CONTACT VALUES(5, 1, '12-OCT-2016', 'Seminar', 1);
  96.  
  97. -- 'Nancy.Jacobs@somewhere.com',
  98. INSERT INTO CONTACT (CustomerID, ContactNumber, ContactDate,  ContactType)
  99.     VALUES(1, 2, '15-OCT-2016', 'EmailSeminarMessage');
  100. -- 'Chantel.Jacobs@somewhere.com'
  101. INSERT INTO CONTACT (CustomerID, ContactNumber, ContactDate,  ContactType)
  102.     VALUES(2, 2, '15-OCT-2016', 'EmailSeminarMessage');
  103. -- 'Ralph.Able@somewhere.com'
  104. INSERT INTO CONTACT (CustomerID, ContactNumber, ContactDate,  ContactType)
  105.     VALUES(3, 2, '15-OCT-2016', 'EmailSeminarMessage');
  106. -- 'Susan.Baker@elsewhere.com'
  107. INSERT INTO CONTACT (CustomerID, ContactNumber, ContactDate,  ContactType)
  108.     VALUES(4, 2, '15-OCT-2016', 'EmailSeminarMessage');
  109. -- 'Sam.Eagleton@elsewhere.com'
  110. INSERT INTO CONTACT (CustomerID, ContactNumber, ContactDate,  ContactType)
  111.     VALUES(5, 2, '15-OCT-2016', 'EmailSeminarMessage');
  112.  
  113.  
  114. -- 'Nancy.Jacobs@somewhere.com',
  115. INSERT INTO CONTACT (CustomerID, ContactNumber, ContactDate,  ContactType)
  116.     VALUES(1, 3, '15-OCT-2016', 'FormLetterSeminar');
  117. -- 'Chantel.Jacobs@somewhere.com'
  118. INSERT INTO CONTACT (CustomerID, ContactNumber, ContactDate,  ContactType)
  119.     VALUES(2, 3, '15-OCT-2016', 'FormLetterSeminar');
  120. -- 'Ralph.Able@somewhere.com'
  121. INSERT INTO CONTACT (CustomerID, ContactNumber, ContactDate,  ContactType)
  122.     VALUES(3, 3, '15-OCT-2016', 'FormLetterSeminar');
  123. -- 'Susan.Baker@elsewhere.com'
  124. INSERT INTO CONTACT (CustomerID, ContactNumber, ContactDate,  ContactType)
  125.     VALUES(4, 3, '15-OCT-2016', 'FormLetterSeminar');
  126. -- 'Sam.Eagleton@elsewhere.com'
  127. INSERT INTO CONTACT (CustomerID, ContactNumber, ContactDate,  ContactType)
  128.     VALUES(5, 3, '15-OCT-2016', 'FormLetterSeminar');
  129.  
  130. -- 'Kathy.Foxtrot@somewhere.com'
  131. INSERT INTO CONTACT VALUES(6, 1, '26-OCT-2016', 'Seminar', 2);
  132. -- 'Sally.George@somewhere.com'
  133. INSERT INTO CONTACT VALUES(7, 1, '26-OCT-2016', 'Seminar', 2);
  134. -- 'Shawn.Hullett@elsewhere.com'
  135. INSERT INTO CONTACT VALUES(8, 1, '26-OCT-2016', 'Seminar', 2);
  136.  
  137. -- 'Kathy.Foxtrot@somewhere.com'
  138. INSERT INTO CONTACT (CustomerID, ContactNumber, ContactDate,  ContactType)
  139.     VALUES(6, 2, '30-OCT-2016', 'EmailSeminarMessage');
  140. -- 'Sally.George@somewhere.com'
  141. INSERT INTO CONTACT (CustomerID, ContactNumber, ContactDate,  ContactType)
  142.     VALUES(7, 2, '30-OCT-2016', 'EmailSeminarMessage');
  143. -- 'Shawn.Hullett@elsewhere.com'
  144. INSERT INTO CONTACT (CustomerID, ContactNumber, ContactDate,  ContactType)
  145.     VALUES(8, 2, '30-OCT-2016', 'EmailSeminarMessage');
  146.  
  147. -- 'Kathy.Foxtrot@somewhere.com'
  148. INSERT INTO CONTACT (CustomerID, ContactNumber, ContactDate,  ContactType)
  149.     VALUES(6, 3, '30-OCT-2016', 'FormLetterSeminar');
  150. -- 'Sally.George@somewhere.com'
  151. INSERT INTO CONTACT (CustomerID, ContactNumber, ContactDate,  ContactType)
  152.     VALUES(7, 3, '30-OCT-2016', 'FormLetterSeminar');
  153. -- 'Shawn.Hullett@elsewhere.com'
  154. INSERT INTO CONTACT (CustomerID, ContactNumber, ContactDate,  ContactType)
  155.     VALUES(8, 3, '30-OCT-2016', 'FormLetterSeminar');
  156.  
  157. -- 'Bobbi.Pearson@elsewhere.com'
  158. INSERT INTO CONTACT VALUES(9, 1, '02-NOV-2016', 'Seminar', 3);
  159. -- 'Terry.Ranger@somewhere.com'
  160. INSERT INTO CONTACT VALUES(10, 1, '02-NOV-2016', 'Seminar', 3);
  161.  
  162. -- 'Bobbi.Pearson@elsewhere.com'
  163. INSERT INTO CONTACT (CustomerID, ContactNumber, ContactDate,  ContactType)
  164.     VALUES(9, 2, '06-NOV-2016', 'EmailSeminarMessage');
  165. -- 'Terry.Ranger@somewhere.com'
  166. INSERT INTO CONTACT (CustomerID, ContactNumber, ContactDate,  ContactType)
  167.     VALUES(10, 2, '06-NOV-2016', 'EmailSeminarMessage');
  168.  
  169. -- 'Bobbi.Pearson@elsewhere.com'
  170. INSERT INTO CONTACT (CustomerID, ContactNumber, ContactDate,  ContactType)
  171.     VALUES(9, 3, '06-NOV-2016', 'FormLetterSeminar');
  172. -- 'Terry.Ranger@somewhere.com'
  173. INSERT INTO CONTACT (CustomerID, ContactNumber, ContactDate,  ContactType)
  174.     VALUES(10, 3, '06-NOV-2016', 'FormLetterSeminar');
  175.  
  176.  
  177. -- 'Ralph.Able@somewhere.com'
  178. INSERT INTO CONTACT (CustomerID, ContactNumber, ContactDate,  ContactType)
  179.     VALUES(3, 4, '20-FEB-2017', 'WebAccountCreation');
  180. -- 'Ralph.Able@somewhere.com'
  181. INSERT INTO CONTACT (CustomerID, ContactNumber, ContactDate,  ContactType)
  182.     VALUES(3, 5, '20-FEB-2017', 'EmailAccountMessage');
  183. -- 'Kathy.Foxtrot@somewhere.com'
  184. INSERT INTO CONTACT (CustomerID, ContactNumber, ContactDate,  ContactType)
  185.     VALUES(6, 4, '22-FEB-2017', 'WebAccountCreation');
  186. -- 'Kathy.Foxtrot@somewhere.com'
  187. INSERT INTO CONTACT (CustomerID, ContactNumber, ContactDate,  ContactType)
  188.     VALUES(6, 5, '22-FEB-2017', 'EmailAccountMessage');
  189. -- 'Sally.George@somewhere.com'
  190. INSERT INTO CONTACT (CustomerID, ContactNumber, ContactDate,  ContactType)
  191.     VALUES(7, 4, '25-FEB-2017', 'WebAccountCreation');
  192. -- 'Sally.George@somewhere.com'
  193. INSERT INTO CONTACT (CustomerID, ContactNumber, ContactDate,  ContactType)
  194.     VALUES(7, 5, '25-FEB-2017', 'EmailAccountMessage');
  195. -- 'Shawn.Hullett@elsewhere.com'
  196. INSERT INTO CONTACT (CustomerID, ContactNumber, ContactDate,  ContactType)
  197.     VALUES(8, 4, '07-MAR-2017', 'WebAccountCreation');
  198. -- 'Shawn.Hullett@elsewhere.com'
  199. INSERT INTO CONTACT (CustomerID, ContactNumber, ContactDate,  ContactType)
  200.     VALUES(8, 5, '07-MAR-2017', 'EmailAccountMessage');
  201.  
  202. -- 'Kathy.Foxtrot@somewhere.com'
  203. INSERT INTO CONTACT VALUES(6, 6, '22-MAR-2017', 'Seminar', 4);
  204. -- 'Sally.George@somewhere.com'
  205. INSERT INTO CONTACT VALUES(7, 6, '22-MAR-2017', 'Seminar', 4);
  206. -- 'Jenny.Tyler@somewhere.com'
  207. INSERT INTO CONTACT VALUES(11, 1, '22-MAR-2017', 'Seminar', 4);
  208. -- 'Joan.Wayne@elsewhere.com'
  209. INSERT INTO CONTACT VALUES(12, 1, '22-MAR-2017', 'Seminar', 4);
  210.  
  211.  
  212. /*****   PRODUCT DATA   *********************************************************/
  213.  
  214. INSERT INTO PRODUCT VALUES(
  215.     'VK001', 'Video', 'Kitchen Remodeling Basics',14.95, 50);
  216. INSERT INTO PRODUCT VALUES(
  217.     'VK002', 'Video', 'Advanced Kitchen Remodeling', 14.95, 35);
  218. INSERT INTO PRODUCT VALUES(
  219.     'VK003', 'Video', 'Kitchen Remodeling Dallas Style', 19.95, 25);
  220. INSERT INTO PRODUCT VALUES(
  221.     'VK004', 'Video', 'Heather Sweeney Seminar Live in Dallas on 25-OCT-15', 24.95, 20);
  222. INSERT INTO PRODUCT VALUES(
  223.     'VB001', 'Video Companion', 'Kitchen Remodeling Basics', 7.99, 50);
  224. INSERT INTO PRODUCT VALUES(
  225.     'VB002', 'Video Companion', 'Advanced Kitchen Remodeling I',7.99, 35);
  226. INSERT INTO PRODUCT VALUES(
  227.     'VB003', 'Video Companion', 'Kitchen Remodeling Dallas Style', 9.99, 25);
  228. INSERT INTO PRODUCT VALUES(
  229.     'BK001', 'Book', 'Kitchen Remodeling Basics For Everyone', 24.95, 75);
  230. INSERT INTO PRODUCT VALUES(
  231.     'BK002', 'Book', 'Advanced Kitchen Remodeling For Everyone', 24.95, 75);
  232. INSERT INTO PRODUCT VALUES(
  233.     'BK003', 'Book', 'Kitchen Remodeling Dallas Style For Everyone', 24.95, 75);
  234.  
  235. /*****   INVOICE DATA    **************************************************/
  236.  
  237. /*****   Invoice 35000   **************************************************/
  238. -- 'Ralph.Able@somewhere.com'
  239. INSERT INTO INVOICE VALUES(
  240.     '15-Oct-2016', 3, 'VISA', 22.94, 5.95, 1.31, 30.20);
  241. INSERT INTO LINE_ITEM VALUES(35000, 1, 'VK001', 1, 14.95, 14.95);
  242. INSERT INTO LINE_ITEM VALUES(35000, 2, 'VB001', 1, 7.99, 7.99);
  243.  
  244. /*****   Invoice 35001   **************************************************/
  245. -- 'Susan.Baker@elsewhere.com'
  246. INSERT INTO INVOICE VALUES(
  247.     '25-Oct-2016', 4, 'MasterCard', 47.89, 5.95, 2.73, 56.57);
  248. INSERT INTO LINE_ITEM VALUES(35001, 1, 'VK001', 1, 14.95, 14.95);
  249. INSERT INTO LINE_ITEM VALUES(35001, 2, 'VB001', 1, 7.99, 7.99);
  250. INSERT INTO LINE_ITEM VALUES(35001, 3, 'BK001', 1, 24.95, 24.95);
  251.  
  252. /*****   Invoice 35002   **************************************************/
  253. -- 'Sally.George@somewhere.com'
  254. INSERT INTO INVOICE VALUES(
  255.     '20-Dec-2016', 7, 'VISA', 24.95, 5.95, 1.42, 32.32);
  256. INSERT INTO LINE_ITEM VALUES(35002, 1, 'VK004', 1, 24.95, 24.95);
  257.  
  258. /*****   Invoice 35003   **************************************************/
  259. -- 'Susan.Baker@elsewhere.com'
  260. INSERT INTO INVOICE VALUES(
  261.     '25-Mar-2017', 4, 'MasterCard', 64.85, 5.95, 3.70, 74.50);
  262. INSERT INTO LINE_ITEM VALUES(35003, 1, 'VK002', 1, 14.95, 14.95);
  263. INSERT INTO LINE_ITEM VALUES(35003, 2, 'BK002', 1, 24.95, 24.95);
  264. INSERT INTO LINE_ITEM VALUES(35003, 3, 'VK004', 1, 24.95, 24.95);
  265.  
  266. /*****   Invoice 35004   ***************************************************/
  267. -- 'Kathy.Foxtrot@somewhere.com'
  268. INSERT INTO INVOICE VALUES(
  269.     '27-Mar-2017', 6, 'MasterCard', 94.79, 5.95, 5.40, 106.14);
  270. INSERT INTO LINE_ITEM VALUES(35004, 1, 'VK002', 1, 14.95, 14.95);
  271. INSERT INTO LINE_ITEM VALUES(35004, 2, 'BK002', 1, 24.95, 24.95);
  272. INSERT INTO LINE_ITEM VALUES(35004, 3, 'VK003', 1, 19.95, 19.95);
  273. INSERT INTO LINE_ITEM VALUES(35004, 4, 'VB003', 1, 9.99, 9.99);
  274. INSERT INTO LINE_ITEM VALUES(35004, 5, 'VK004', 1, 24.95, 24.95);
  275.  
  276. /*****   Invoice 35005   ***************************************************/
  277. -- 'Sally.George@somewhere.com'
  278. INSERT INTO INVOICE VALUES(
  279.     '27-Mar-2017', 7, 'MasterCard', 94.80, 5.95, 5.40, 106.15);
  280. INSERT INTO LINE_ITEM VALUES(35005, 1, 'BK001', 1, 24.95, 24.95);
  281. INSERT INTO LINE_ITEM VALUES(35005, 2, 'BK002', 1, 24.95, 24.95);
  282. INSERT INTO LINE_ITEM VALUES(35005, 3, 'VK003', 1, 19.95, 19.95);
  283. INSERT INTO LINE_ITEM VALUES(35005, 4, 'VK004', 1, 24.95, 24.95);
  284.  
  285. /*****   Invoice 35006   ***************************************************/
  286. -- 'Bobbi.Pearson@elsewhere.com'
  287. INSERT INTO INVOICE VALUES(
  288.     '31-Mar-2017', 9, 'VISA', 47.89,    5.95, 2.73, 56.57);
  289. INSERT INTO LINE_ITEM VALUES(35006, 1, 'BK001', 1, 24.95, 24.95);
  290. INSERT INTO LINE_ITEM VALUES(35006, 2, 'VK001', 1, 14.95, 14.95);
  291. INSERT INTO LINE_ITEM VALUES(35006, 3, 'VB001', 1, 7.99, 7.99);
  292.  
  293. /*****   Invoice 35007   ***************************************************/
  294. -- 'Jenny.Tyler@somewhere.com'
  295. INSERT INTO INVOICE VALUES(
  296.     '03-Apr-2017', 11, 'MasterCard', 109.78, 5.95, 6.26, 121.99);
  297. INSERT INTO LINE_ITEM VALUES(35007, 1, 'VK003', 2, 19.95, 39.90);
  298. INSERT INTO LINE_ITEM VALUES(35007, 2, 'VB003', 2, 9.99, 19.98);
  299. INSERT INTO LINE_ITEM VALUES(35007, 3, 'VK004', 2, 24.95, 49.90);
  300.  
  301. /*****   Invoice 35008   ***************************************************/
  302. -- 'Sam.Eagleton@elsewhere.com'
  303. INSERT INTO INVOICE VALUES(
  304.     '08-Apr-2017', 5, 'MasterCard', 47.89, 5.95, 2.73, 56.57);
  305. INSERT INTO LINE_ITEM VALUES(35008, 1, 'BK001', 1, 24.95, 24.95);
  306. INSERT INTO LINE_ITEM VALUES(35008, 2, 'VK001', 1, 14.95, 14.95);
  307. INSERT INTO LINE_ITEM VALUES(35008, 3, 'VB001', 1, 7.99, 7.99);
  308.  
  309. /*****   Invoice 35009   ***************************************************/
  310. -- 'Nancy.Jacobs@somewhere.com'
  311. INSERT INTO INVOICE VALUES(
  312.     '08-Apr-2017', 1, 'VISA', 47.89,    5.95, 2.73, 56.57);
  313. INSERT INTO LINE_ITEM VALUES(35009, 1, 'BK001', 1, 24.95, 24.95);
  314. INSERT INTO LINE_ITEM VALUES(35009, 2, 'VK001', 1, 14.95, 14.95);
  315. INSERT INTO LINE_ITEM VALUES(35009, 3, 'VB001', 1, 7.99, 7.99);
  316.  
  317. /*****   Invoice 35010   ***************************************************/
  318. -- 'Ralph.Able@somewhere.com'
  319. INSERT INTO INVOICE VALUES(
  320.     '23-Apr-2017', 3, 'VISA', 24.95,    5.95, 1.42, 32.32);
  321. INSERT INTO LINE_ITEM VALUES(35010, 1, 'BK001', 1, 24.95, 24.95);
  322.  
  323. /*****   Invoice 35011   ***************************************************/
  324. -- 'Bobbi.Pearson@elsewhere.com'
  325. INSERT INTO INVOICE VALUES(
  326.     '07-May-2017', 9, 'VISA', 22.94,    5.95, 1.31, 30.20);
  327. INSERT INTO LINE_ITEM VALUES(35011, 1, 'VK002', 1, 14.95, 14.95);
  328. INSERT INTO LINE_ITEM VALUES(35011, 2, 'VB002', 1, 7.99, 7.99);
  329.  
  330. /*****   Invoice 35012   ***************************************************/
  331. -- 'Shawn.Hullett@elsewhere.com'
  332. INSERT INTO INVOICE VALUES(
  333.     '21-May-2017', 8, 'MasterCard', 54.89, 5.95, 3.13, 63.97);
  334. INSERT INTO LINE_ITEM VALUES(35012, 1, 'VK003', 1, 19.95, 19.95);
  335. INSERT INTO LINE_ITEM VALUES(35012, 2, 'VB003', 1, 9.99, 9.99);
  336. INSERT INTO LINE_ITEM VALUES(35012, 3, 'VK004', 1, 24.95, 24.95);
  337.  
  338. /*****   Invoice 35013   ***************************************************/
  339. -- 'Ralph.Able@somewhere.com'
  340. INSERT INTO INVOICE VALUES(
  341.     '05-Jun-2017', 3, 'VISA', 47.89,    5.95, 2.73, 56.57);
  342. INSERT INTO LINE_ITEM VALUES(35013, 1, 'VK002', 1, 14.95, 14.95);
  343. INSERT INTO LINE_ITEM VALUES(35013, 2, 'VB002', 1, 7.99, 7.99);
  344. INSERT INTO LINE_ITEM VALUES(35013, 3, 'BK002', 1, 24.95, 24.95);
  345.  
  346. /*****   Invoice 35014   ***************************************************/
  347. -- 'Jenny.Tyler@somewhere.com'
  348. INSERT INTO INVOICE VALUES(
  349.     '05-Jun-2017', 11, 'MasterCard', 45.88, 5.95, 2.62, 54.45);
  350. INSERT INTO LINE_ITEM VALUES(35014, 1, 'VK002', 2, 14.95, 29.90);
  351. INSERT INTO LINE_ITEM VALUES(35014, 2, 'VB002', 2, 7.99, 15.98);
  352.  
  353. /*****   Invoice 35015   ***************************************************/
  354. -- 'Joan.Wayne@elsewhere.com'
  355. INSERT INTO INVOICE VALUES(
  356.     '05-Jun-2017', 12, 'MasterCard', 94.79, 5.95, 5.40, 106.14);
  357. INSERT INTO LINE_ITEM VALUES(35015, 1, 'VK002', 1, 14.95, 14.95);
  358. INSERT INTO LINE_ITEM VALUES(35015, 2, 'BK002', 1, 24.95, 24.95);
  359. INSERT INTO LINE_ITEM VALUES(35015, 3, 'VK003', 1, 19.95, 19.95);
  360. INSERT INTO LINE_ITEM VALUES(35015, 4, 'VB003', 1, 9.99, 9.99);
  361. INSERT INTO LINE_ITEM VALUES(35015, 5, 'VK004', 1, 24.95, 24.95);
  362.  
  363. /*****   Invoice 35016   ***************************************************/
  364. -- 'Ralph.Able@somewhere.com'
  365. INSERT INTO INVOICE VALUES(
  366.     '05-Jun-2017', 3, 'VISA', 45.88,    5.95, 2.62, 54.45);
  367. INSERT INTO LINE_ITEM VALUES(35016, 1, 'VK001', 1, 14.95, 14.95);
  368. INSERT INTO LINE_ITEM VALUES(35016, 2, 'VB001', 1, 7.99, 7.99);
  369. INSERT INTO LINE_ITEM VALUES(35016, 3, 'VK002', 1, 14.95, 14.95);
  370. INSERT INTO LINE_ITEM VALUES(35016, 4, 'VB002', 1, 7.99, 7.99);
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top