@srkirkland I think the query might need to not just be the questions where evaluationid, but where the scale.id = the master department scale.id so it might have to be something like:

select Prompt, [Order], AnswerType, QuestionType, ClassTypeId as ClassType 
from Questions where ScaleId = (select ScaleId from Departments where Id = '||||')

It's because everytime the master questions are modified, they get a new scale and a new set of questions inserted.  This keeps different the new versions separate from old versions.