Last active
August 29, 2015 14:18
-
-
Save hanleybrand/be5732757c7c658c0e88 to your computer and use it in GitHub Desktop.
Problem with step 0b (Case #02139497 - group assignment attempts are not viewable in this course)
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- I get | |
| -- IDENTITY_INSERT is already ON for table 'bb_bb60.dbo.group_attempt_files_prv'. Cannot perform SET operation for table 'attempt_prv' | |
| -- if I set it ON and | |
| -- Cannot insert explicit value for identity column in table 'attempt_prv' when IDENTITY_INSERT is set to OFF. | |
| SET IDENTITY_INSERT attempt_prv ON; | |
| INSERT INTO attempt_prv | |
| ([GRADEBOOK_GRADE_PK1], [PK1], [QTI_RESULT_DATA_PK1], [LINKREFID], [SCORE], | |
| [GRADE], [STUDENT_COMMENTS], [INSTRUCTOR_COMMENTS], [INSTRUCTOR_NOTES], [STATUS], | |
| [ATTEMPT_DATE], [DATE_ADDED], [DATE_MODIFIED], [LATEST_IND], [comment_public_ind], | |
| [exempt_ind], [override_ind], [group_attempt_pk1], [student_submission], | |
| [text_format_type], [feedback_format_type], [notes_format_type], | |
| [first_graded_date], [last_graded_date], [graded_anonymously_ind], | |
| [reconciliation_mode], [show_staged_feedback]) | |
| SELECT [GRADEBOOK_GRADE_PK1], [PK1], [QTI_RESULT_DATA_PK1], [LINKREFID], [SCORE], | |
| [GRADE], [STUDENT_COMMENTS], [INSTRUCTOR_COMMENTS], [INSTRUCTOR_NOTES], [STATUS], | |
| [ATTEMPT_DATE], [DATE_ADDED], [DATE_MODIFIED], [LATEST_IND], [comment_public_ind], | |
| [exempt_ind], [override_ind], [group_attempt_pk1], [student_submission], | |
| [text_format_type], [feedback_format_type], [notes_format_type], | |
| [first_graded_date], [last_graded_date], [graded_anonymously_ind], | |
| [reconciliation_mode], [show_staged_feedback] | |
| from attempt where group_attempt_pk1 in | |
| (select pk1 from group_attempt where gradebook_main_pk1 in | |
| (select pk1 from gradebook_main where crsmain_pk1 in | |
| (select pk1 from course_main where course_id = '88200713415')) and groups_pk1 is NULL | |
| SET IDENTITY_INSERT attempt_prv OFF; | |
| -- had to use a column list, was getting this error with Select * INTO table_prv from table: | |
| --An explicit value for the identity column in table 'group_attempt_prv' can only be specified when a column list is used and IDENTITY_INSERT is ON. |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment