API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Feb 19th, 2019
90
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 17.06 KB | None | 0 0
raw download clone embed print report
  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);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
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
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!