-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathSatler_Extra_Data_Files.sql
72 lines (50 loc) · 1.99 KB
/
Satler_Extra_Data_Files.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
--Added Data
INSERT INTO EdSetting (EdSettingID, StudentEdSettingLinkID, SchoolName)
VALUES (200, 100, 'Fabulous Middle')
UPDATE StudentEdSettingLink
SET EdSettingID = 200
WHERE StudentID = 1;
INSERT INTO EdSetting (EdSettingID, StudentEdSettingLinkID, SchoolName)
VALUES (201, 101, 'Great Elementary')
UPDATE StudentEdSettingLink
SET EdSettingID = 201
WHERE StudentID = 2;
INSERT INTO EdSetting (EdSettingID, StudentEdSettingLinkID, SchoolName)
VALUES (202, 102, 'Fabulous Middle')
UPDATE StudentEdSettingLink
SET EdSettingID = 202
WHERE StudentID = 3;
INSERT INTO EdSetting (EdSettingID, StudentEdSettingLinkID, SchoolName)
VALUES (203, 103, 'Tough High')
UPDATE StudentEdSettingLink
SET EdSettingID = 203
WHERE StudentID = 4;
INSERT INTO Student(StudentID, StuFirstName, StuLastName, Grade, DOB, Eligibility)
VALUES (10, 'Janet', 'Jones', 4, '5/15/2012', 'LD');
Select *
FROM Student;
UPDATE Student
SET Grade = 3
WHERE StudentID = 10;
UPDATE Student
SET Grade = 5
WHERE StudentID = 10;
UPDATE Student
SET Grade = 4
WHERE StudentID = 10;
Select *
FROM GradeChange
Select *
FROM IEPTime
INSERT INTO IEPTime (TimeID, SpecID, IEPMinutes, IEPFrequency)
VALUES (500, 400, 30, 9)
INSERT INTO CaseManager (CaseManagerID, StudentID, CMFirstName, CMLastName, CMStartDate, CMEndDate)
VALUES (600, 1, 'Billy', 'Borders', '8/1/2010', NULL)
INSERT INTO CaseManager (CaseManagerID, StudentID, CMFirstName, CMLastName, CMStartDate, CMEndDate)
VALUES (601, 2, 'Sam', 'Jones', '8/1/2010', NULL)
INSERT INTO CaseManager (CaseManagerID, StudentID, CMFirstName, CMLastName, CMStartDate, CMEndDate)
VALUES (602, 3, 'Steve', 'Carter', '8/1/2019', NULL)
INSERT INTO CaseManager (CaseManagerID, StudentID, CMFirstName, CMLastName, CMStartDate, CMEndDate)
VALUES (603, 4, 'Mel', 'Brooks', '8/1/2019', NULL)
INSERT INTO Specialist(SpecID, LicenseNum, SpecFirstName, SpecLastName, SpecStartDate)
VALUES (@SpecID, @LicenseNum, @SpecFirstName, @SpecLastName, @SpecStartDate)