Advertisement
Guest User

Untitled

a guest
Nov 3rd, 2015
56
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 13.04 KB | None | 0 0
  1. CREATE TABLE [dbo].[SAMPLE_TABLE2](
  2.     [SUBJECT_ID] [INT] NOT NULL,
  3.     [HOURS] [FLOAT] NULL,
  4.     [POINTS] [FLOAT] NULL,
  5.     [SEMESTER_ID] [INT] NOT NULL
  6. ) ON [PRIMARY]
  7. GO
  8. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (40, 0, 1, 214858)
  9. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (40, 30, 0, 214858)
  10. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (236, 30, 0, 214858)
  11. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (236, 0, 2, 214858)
  12. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (236, 0, 2, 233562)
  13. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (236, 30, 0, 233562)
  14. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (257, 20, 0, 243731)
  15. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (257, 10, 0, 243731)
  16. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (257, 0, 1, 243731)
  17. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (337, 2, 0, 214858)
  18. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (337, 0, 2, 214858)
  19. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (337, 18, 0, 214858)
  20. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (353, 0, 1, 243731)
  21. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (353, 15, 0, 243731)
  22. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (353, 30, 0, 243731)
  23. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (377, 8, 0, 276758)
  24. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (377, 36, 0, 276758)
  25. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (377, 0, 2, 276758)
  26. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (401, 0, 4, 214858)
  27. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (401, 0, 4, 214858)
  28. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (401, 0, 4, 214858)
  29. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (401, 40, 0, 214858)
  30. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (401, 4, 0, 214858)
  31. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (652, 0, 2, 214858)
  32. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (652, 0, 2, 214858)
  33. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (652, 0, 2, 214858)
  34. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (652, 30, 0, 214858)
  35. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (652, 0, 1, 243731)
  36. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (652, 0, 1, 243731)
  37. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (652, 0, 1, 243731)
  38. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (652, 26, 0, 243731)
  39. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (652, 0, 2, 233562)
  40. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (652, 0, 2, 233562)
  41. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (652, 30, 0, 233562)
  42. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (753, 18, 0, 276758)
  43. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (753, 9, 0, 276758)
  44. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (753, 18, 0, 276758)
  45. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (753, 0, 2, 276758)
  46. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (780, 10, 0, 243731)
  47. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (780, 20, 0, 243731)
  48. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (780, 0, 1, 243731)
  49. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (782, 51, 0, 233562)
  50. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (782, 0, 8, 233562)
  51. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (782, 0, 8, 233562)
  52. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (782, 4, 0, 233562)
  53. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (782, 49, 0, 214858)
  54. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (782, 45, 0, 233562)
  55. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (782, 0, 8, 214858)
  56. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (782, 0, 8, 214858)
  57. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (782, 6, 0, 214858)
  58. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (782, 45, 0, 214858)
  59. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (802, 0, 2, 233562)
  60. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (802, 16, 0, 233562)
  61. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (802, 4, 0, 233562)
  62. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (823, 2, 0, 214858)
  63. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (823, 0, 0, 214858)
  64. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (830, 18, 0, 243731)
  65. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (830, 26, 0, 243731)
  66. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (830, 18, 0, 243731)
  67. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (830, 0, 4, 243731)
  68. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (830, 0, 4, 243731)
  69. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (861, 3, 0, 276758)
  70. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (861, 47, 0, 276758)
  71. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (861, 0, 0, 276758)
  72. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (1335, 0, 4, 243731)
  73. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (1335, 0, 4, 243731)
  74. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (1335, 8, 0, 243731)
  75. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (1335, 44, 0, 243731)
  76. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (1373, 0, 2, 233562)
  77. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (1373, 10, 0, 233562)
  78. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (1373, 10, 0, 233562)
  79. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (1443, 0, 4, 233562)
  80. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (1443, 15, 0, 233562)
  81. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (1443, 30, 0, 233562)
  82. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (1484, 20, 0, 214858)
  83. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (1484, 0, 3, 214858)
  84. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (1484, 0, 3, 214858)
  85. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (1484, 0, 3, 214858)
  86. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (1484, 10, 0, 214858)
  87. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (1488, 8, 0, 276758)
  88. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (1488, 0, 6, 276758)
  89. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (1488, 52, 0, 276758)
  90. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (1488, 52, 0, 243731)
  91. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (1488, 8, 0, 243731)
  92. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (1488, 0, 6, 243731)
  93. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (1488, 0, 6, 243731)
  94. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (1488, 0, 6, 243731)
  95. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (1503, 70, 0, 243731)
  96. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (1503, 30, 0, 243731)
  97. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (1503, 0, 5, 243731)
  98. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (1533, 30, 0, 233562)
  99. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (1533, 10, 0, 256919)
  100. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (1533, 0, 4, 256919)
  101. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (1533, 30, 0, 256919)
  102. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (1533, 0, 4, 233562)
  103. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (1533, 0, 4, 233562)
  104. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (1533, 0, 4, 233562)
  105. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (1533, 10, 0, 233562)
  106. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (1743, 10, 0, 276758)
  107. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (1743, 10, 0, 276758)
  108. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (1743, 0, 1, 276758)
  109. GO
  110. print 'Processed 100 total records'
  111. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (2384, 30, 0, 214858)
  112. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (2384, 0, 4, 214858)
  113. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (2384, 0, 4, 214858)
  114. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (2384, 0, 4, 214858)
  115. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (2385, 0, 1, 214858)
  116. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (2385, 15, 0, 214858)
  117. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (2385, 2, 0, 214858)
  118. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (2407, 0, 2, 243731)
  119. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (2407, 0, 2, 243731)
  120. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (2407, 0, 2, 243731)
  121. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (2407, 15, 0, 243731)
  122. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (2419, 90, 0, 256919)
  123. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (2419, 0, 3, 256919)
  124. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (2479, 0, 2, 233562)
  125. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (2479, 20, 0, 233562)
  126. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (2479, 10, 0, 233562)
  127. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (2945, 25, 0, 214858)
  128. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (2945, 5, 0, 214858)
  129. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (2945, 0, 3, 214858)
  130. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (2993, 0, 4, 233562)
  131. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (2993, 120, 0, 233562)
  132. INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (3222, 0, 2, 276758)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement