Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE [dbo].[SAMPLE_TABLE2](
- [SUBJECT_ID] [INT] NOT NULL,
- [HOURS] [FLOAT] NULL,
- [POINTS] [FLOAT] NULL,
- [SEMESTER_ID] [INT] NOT NULL
- ) ON [PRIMARY]
- GO
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (40, 0, 1, 214858)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (40, 30, 0, 214858)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (236, 30, 0, 214858)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (236, 0, 2, 214858)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (236, 0, 2, 233562)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (236, 30, 0, 233562)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (257, 20, 0, 243731)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (257, 10, 0, 243731)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (257, 0, 1, 243731)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (337, 2, 0, 214858)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (337, 0, 2, 214858)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (337, 18, 0, 214858)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (353, 0, 1, 243731)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (353, 15, 0, 243731)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (353, 30, 0, 243731)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (377, 8, 0, 276758)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (377, 36, 0, 276758)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (377, 0, 2, 276758)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (401, 0, 4, 214858)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (401, 0, 4, 214858)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (401, 0, 4, 214858)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (401, 40, 0, 214858)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (401, 4, 0, 214858)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (652, 0, 2, 214858)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (652, 0, 2, 214858)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (652, 0, 2, 214858)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (652, 30, 0, 214858)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (652, 0, 1, 243731)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (652, 0, 1, 243731)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (652, 0, 1, 243731)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (652, 26, 0, 243731)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (652, 0, 2, 233562)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (652, 0, 2, 233562)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (652, 30, 0, 233562)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (753, 18, 0, 276758)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (753, 9, 0, 276758)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (753, 18, 0, 276758)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (753, 0, 2, 276758)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (780, 10, 0, 243731)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (780, 20, 0, 243731)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (780, 0, 1, 243731)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (782, 51, 0, 233562)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (782, 0, 8, 233562)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (782, 0, 8, 233562)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (782, 4, 0, 233562)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (782, 49, 0, 214858)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (782, 45, 0, 233562)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (782, 0, 8, 214858)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (782, 0, 8, 214858)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (782, 6, 0, 214858)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (782, 45, 0, 214858)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (802, 0, 2, 233562)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (802, 16, 0, 233562)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (802, 4, 0, 233562)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (823, 2, 0, 214858)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (823, 0, 0, 214858)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (830, 18, 0, 243731)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (830, 26, 0, 243731)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (830, 18, 0, 243731)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (830, 0, 4, 243731)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (830, 0, 4, 243731)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (861, 3, 0, 276758)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (861, 47, 0, 276758)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (861, 0, 0, 276758)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (1335, 0, 4, 243731)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (1335, 0, 4, 243731)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (1335, 8, 0, 243731)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (1335, 44, 0, 243731)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (1373, 0, 2, 233562)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (1373, 10, 0, 233562)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (1373, 10, 0, 233562)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (1443, 0, 4, 233562)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (1443, 15, 0, 233562)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (1443, 30, 0, 233562)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (1484, 20, 0, 214858)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (1484, 0, 3, 214858)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (1484, 0, 3, 214858)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (1484, 0, 3, 214858)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (1484, 10, 0, 214858)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (1488, 8, 0, 276758)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (1488, 0, 6, 276758)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (1488, 52, 0, 276758)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (1488, 52, 0, 243731)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (1488, 8, 0, 243731)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (1488, 0, 6, 243731)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (1488, 0, 6, 243731)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (1488, 0, 6, 243731)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (1503, 70, 0, 243731)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (1503, 30, 0, 243731)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (1503, 0, 5, 243731)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (1533, 30, 0, 233562)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (1533, 10, 0, 256919)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (1533, 0, 4, 256919)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (1533, 30, 0, 256919)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (1533, 0, 4, 233562)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (1533, 0, 4, 233562)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (1533, 0, 4, 233562)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (1533, 10, 0, 233562)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (1743, 10, 0, 276758)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (1743, 10, 0, 276758)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (1743, 0, 1, 276758)
- GO
- print 'Processed 100 total records'
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (2384, 30, 0, 214858)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (2384, 0, 4, 214858)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (2384, 0, 4, 214858)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (2384, 0, 4, 214858)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (2385, 0, 1, 214858)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (2385, 15, 0, 214858)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (2385, 2, 0, 214858)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (2407, 0, 2, 243731)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (2407, 0, 2, 243731)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (2407, 0, 2, 243731)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (2407, 15, 0, 243731)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (2419, 90, 0, 256919)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (2419, 0, 3, 256919)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (2479, 0, 2, 233562)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (2479, 20, 0, 233562)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (2479, 10, 0, 233562)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (2945, 25, 0, 214858)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (2945, 5, 0, 214858)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (2945, 0, 3, 214858)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (2993, 0, 4, 233562)
- INSERT [dbo].[SAMPLE_TABLE2] ([SUBJECT_ID], [HOURS], [POINTS], [SEMESTER_ID]) VALUES (2993, 120, 0, 233562)
- 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