Skip to content

Instantly share code, notes, and snippets.

@hanleybrand
Last active August 29, 2015 14:18
Show Gist options
  • Save hanleybrand/be5732757c7c658c0e88 to your computer and use it in GitHub Desktop.
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)
-- 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