API tools faq
paste
Guest User

Untitled

a guest
Feb 19th, 2019
111
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', '[email protected]', 'nf46tG9E', '817-871-8123',
  8. '1440 West Palm Drive', 'Fort Worth', 'TX', '76110');
  9. INSERT INTO CUSTOMER VALUES(
  10. 'Jacobs', 'Chantel', '[email protected]', 'b65TG03f', '817-871-8234',
  11. '1550 East Palm Drive', 'Fort Worth', 'TX', '76112');
  12. INSERT INTO CUSTOMER VALUES(
  13. 'Able', 'Ralph', '[email protected]', 'm56fGH08', '210-281-7987',
  14. '123 Elm Street', 'San Antonio', 'TX', '78214');
  15. INSERT INTO CUSTOMER VALUES(
  16. 'Baker', 'Susan', '[email protected]', 'PC93fEk9', '210-281-7876',
  17. '456 Oak Street', 'San Antonio', 'TX', '78216');
  18. INSERT INTO CUSTOMER VALUES(
  19. 'Eagleton', 'Sam', '[email protected]', 'bnvR44W8', '210-281-7765',
  20. '789 Pine Street', 'San Antonio', 'TX', '78218');
  21. INSERT INTO CUSTOMER VALUES(
  22. 'Foxtrot', 'Kathy', '[email protected]', 'aa8tY4GL', '972-233-6234',
  23. '11023 Elm Street', 'Dallas', 'TX', '75220');
  24. INSERT INTO CUSTOMER VALUES(
  25. 'George', 'Sally', '[email protected]', 'LK8G2tyF', '972-233-6345',
  26. '12034 San Jacinto', 'Dallas', 'TX', '75223');
  27. INSERT INTO CUSTOMER VALUES(
  28. 'Hullett', 'Shawn', '[email protected]', 'bu78WW3t', '972-233-6456',
  29. '13045 Flora', 'Dallas', 'TX', '75224');
  30. INSERT INTO CUSTOMER VALUES(
  31. 'Pearson', 'Bobbi', '[email protected]', 'kq6N2O0p', '512-974-3344',
  32. '43 West 23rd Street', 'Austin', 'TX', '78710');
  33. INSERT INTO CUSTOMER VALUES(
  34. 'Ranger', 'Terry', '[email protected]', 'bv3F9Qc4', '512-974-4455',
  35. '56 East 18th Street', 'Austin', 'TX', '78712');
  36. INSERT INTO CUSTOMER VALUES(
  37. 'Tyler', 'Jenny', '[email protected]', 'Yu4be77Z', '972-233-6567',
  38. '14056 South Ervay Street', 'Dallas', 'TX', '75225');
  39. INSERT INTO CUSTOMER VALUES(
  40. 'Wayne', 'Joan', '[email protected]', '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. -- '[email protected]'
  87. INSERT INTO CONTACT VALUES(1, 1, '12-OCT-2016', 'Seminar', 1);
  88. -- '[email protected]'
  89. INSERT INTO CONTACT VALUES(2, 1, '12-OCT-2016', 'Seminar', 1);
  90. -- '[email protected]'
  91. INSERT INTO CONTACT VALUES(3, 1, '12-OCT-2016', 'Seminar', 1);
  92. -- '[email protected]'
  93. INSERT INTO CONTACT VALUES(4, 1, '12-OCT-2016', 'Seminar', 1);
  94. -- '[email protected]'
  95. INSERT INTO CONTACT VALUES(5, 1, '12-OCT-2016', 'Seminar', 1);
  96.  
  97. -- '[email protected]',
  98. INSERT INTO CONTACT (CustomerID, ContactNumber, ContactDate, ContactType)
  99. VALUES(1, 2, '15-OCT-2016', 'EmailSeminarMessage');
  100. -- '[email protected]'
  101. INSERT INTO CONTACT (CustomerID, ContactNumber, ContactDate, ContactType)
  102. VALUES(2, 2, '15-OCT-2016', 'EmailSeminarMessage');
  103. -- '[email protected]'
  104. INSERT INTO CONTACT (CustomerID, ContactNumber, ContactDate, ContactType)
  105. VALUES(3, 2, '15-OCT-2016', 'EmailSeminarMessage');
  106. -- '[email protected]'
  107. INSERT INTO CONTACT (CustomerID, ContactNumber, ContactDate, ContactType)
  108. VALUES(4, 2, '15-OCT-2016', 'EmailSeminarMessage');
  109. -- '[email protected]'
  110. INSERT INTO CONTACT (CustomerID, ContactNumber, ContactDate, ContactType)
  111. VALUES(5, 2, '15-OCT-2016', 'EmailSeminarMessage');
  112.  
  113.  
  114. -- '[email protected]',
  115. INSERT INTO CONTACT (CustomerID, ContactNumber, ContactDate, ContactType)
  116. VALUES(1, 3, '15-OCT-2016', 'FormLetterSeminar');
  117. -- '[email protected]'
  118. INSERT INTO CONTACT (CustomerID, ContactNumber, ContactDate, ContactType)
  119. VALUES(2, 3, '15-OCT-2016', 'FormLetterSeminar');
  120. -- '[email protected]'
  121. INSERT INTO CONTACT (CustomerID, ContactNumber, ContactDate, ContactType)
  122. VALUES(3, 3, '15-OCT-2016', 'FormLetterSeminar');
  123. -- '[email protected]'
  124. INSERT INTO CONTACT (CustomerID, ContactNumber, ContactDate, ContactType)
  125. VALUES(4, 3, '15-OCT-2016', 'FormLetterSeminar');
  126. -- '[email protected]'
  127. INSERT INTO CONTACT (CustomerID, ContactNumber, ContactDate, ContactType)
  128. VALUES(5, 3, '15-OCT-2016', 'FormLetterSeminar');
  129.  
  130. -- '[email protected]'
  131. INSERT INTO CONTACT VALUES(6, 1, '26-OCT-2016', 'Seminar', 2);
  132. -- '[email protected]'
  133. INSERT INTO CONTACT VALUES(7, 1, '26-OCT-2016', 'Seminar', 2);
  134. -- '[email protected]'
  135. INSERT INTO CONTACT VALUES(8, 1, '26-OCT-2016', 'Seminar', 2);
  136.  
  137. -- '[email protected]'
  138. INSERT INTO CONTACT (CustomerID, ContactNumber, ContactDate, ContactType)
  139. VALUES(6, 2, '30-OCT-2016', 'EmailSeminarMessage');
  140. -- '[email protected]'
  141. INSERT INTO CONTACT (CustomerID, ContactNumber, ContactDate, ContactType)
  142. VALUES(7, 2, '30-OCT-2016', 'EmailSeminarMessage');
  143. -- '[email protected]'
  144. INSERT INTO CONTACT (CustomerID, ContactNumber, ContactDate, ContactType)
  145. VALUES(8, 2, '30-OCT-2016', 'EmailSeminarMessage');
  146.  
  147. -- '[email protected]'
  148. INSERT INTO CONTACT (CustomerID, ContactNumber, ContactDate, ContactType)
  149. VALUES(6, 3, '30-OCT-2016', 'FormLetterSeminar');
  150. -- '[email protected]'
  151. INSERT INTO CONTACT (CustomerID, ContactNumber, ContactDate, ContactType)
  152. VALUES(7, 3, '30-OCT-2016', 'FormLetterSeminar');
  153. -- '[email protected]'
  154. INSERT INTO CONTACT (CustomerID, ContactNumber, ContactDate, ContactType)
  155. VALUES(8, 3, '30-OCT-2016', 'FormLetterSeminar');
  156.  
  157. -- '[email protected]'
  158. INSERT INTO CONTACT VALUES(9, 1, '02-NOV-2016', 'Seminar', 3);
  159. -- '[email protected]'
  160. INSERT INTO CONTACT VALUES(10, 1, '02-NOV-2016', 'Seminar', 3);
  161.  
  162. -- '[email protected]'
  163. INSERT INTO CONTACT (CustomerID, ContactNumber, ContactDate, ContactType)
  164. VALUES(9, 2, '06-NOV-2016', 'EmailSeminarMessage');
  165. -- '[email protected]'
  166. INSERT INTO CONTACT (CustomerID, ContactNumber, ContactDate, ContactType)
  167. VALUES(10, 2, '06-NOV-2016', 'EmailSeminarMessage');
  168.  
  169. -- '[email protected]'
  170. INSERT INTO CONTACT (CustomerID, ContactNumber, ContactDate, ContactType)
  171. VALUES(9, 3, '06-NOV-2016', 'FormLetterSeminar');
  172. -- '[email protected]'
  173. INSERT INTO CONTACT (CustomerID, ContactNumber, ContactDate, ContactType)
  174. VALUES(10, 3, '06-NOV-2016', 'FormLetterSeminar');
  175.  
  176.  
  177. -- '[email protected]'
  178. INSERT INTO CONTACT (CustomerID, ContactNumber, ContactDate, ContactType)
  179. VALUES(3, 4, '20-FEB-2017', 'WebAccountCreation');
  180. -- '[email protected]'
  181. INSERT INTO CONTACT (CustomerID, ContactNumber, ContactDate, ContactType)
  182. VALUES(3, 5, '20-FEB-2017', 'EmailAccountMessage');
  183. -- '[email protected]'
  184. INSERT INTO CONTACT (CustomerID, ContactNumber, ContactDate, ContactType)
  185. VALUES(6, 4, '22-FEB-2017', 'WebAccountCreation');
  186. -- '[email protected]'
  187. INSERT INTO CONTACT (CustomerID, ContactNumber, ContactDate, ContactType)
  188. VALUES(6, 5, '22-FEB-2017', 'EmailAccountMessage');
  189. -- '[email protected]'
  190. INSERT INTO CONTACT (CustomerID, ContactNumber, ContactDate, ContactType)
  191. VALUES(7, 4, '25-FEB-2017', 'WebAccountCreation');
  192. -- '[email protected]'
  193. INSERT INTO CONTACT (CustomerID, ContactNumber, ContactDate, ContactType)
  194. VALUES(7, 5, '25-FEB-2017', 'EmailAccountMessage');
  195. -- '[email protected]'
  196. INSERT INTO CONTACT (CustomerID, ContactNumber, ContactDate, ContactType)
  197. VALUES(8, 4, '07-MAR-2017', 'WebAccountCreation');
  198. -- '[email protected]'
  199. INSERT INTO CONTACT (CustomerID, ContactNumber, ContactDate, ContactType)
  200. VALUES(8, 5, '07-MAR-2017', 'EmailAccountMessage');
  201.  
  202. -- '[email protected]'
  203. INSERT INTO CONTACT VALUES(6, 6, '22-MAR-2017', 'Seminar', 4);
  204. -- '[email protected]'
  205. INSERT INTO CONTACT VALUES(7, 6, '22-MAR-2017', 'Seminar', 4);
  206. -- '[email protected]'
  207. INSERT INTO CONTACT VALUES(11, 1, '22-MAR-2017', 'Seminar', 4);
  208. -- '[email protected]'
  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. -- '[email protected]'
  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. -- '[email protected]'
  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. -- '[email protected]'
  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. -- '[email protected]'
  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. -- '[email protected]'
  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. -- '[email protected]'
  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. -- '[email protected]'
  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. -- '[email protected]'
  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. -- '[email protected]'
  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. -- '[email protected]'
  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. -- '[email protected]'
  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. -- '[email protected]'
  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. -- '[email protected]'
  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. -- '[email protected]'
  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. -- '[email protected]'
  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. -- '[email protected]'
  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. -- '[email protected]'
  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
Public Pastes
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!