Hi All,
Assessments (assessmentid identity(1,1), title varchar(100),sectionid int,maxpoints decimal)
SLOAssessments(assessmentid int,sloid int ,weight)
Note assessmentid,sloid is a composite primary key
I am importing all assessments of section 1 to section2 and also there corresponding records for sloassessments
Example
Assessments:
1,1,introduction,100
2,1,chapter1, 100
3,1,chapter3, 100
Sloassessments
1,1,40
2,1,60
2,1,30,
2,1,70
SLO student learning outcomes
What is the best way to do it without using cursors
Thanks