I have this statement below.
My assessments table contains 2 published assessments, I want to update the published questions table with the published assessment id, but I keep getting query contained more than one result.
I just want to update individual records from another table.
Maybe I should use a cursor!
Would be grateful for any help.
SET PublishedAssessmentID =
FROM tbl_M05_PublishedAssessments PA
WHERE PA.AssessmentID in (Select AssessmentId from tbl_M05_Assessments PAQ)
and PA.PublishedCourseId = @PublishedOnlineCourseReturnID)