Sorry I forgot to add the questionID to the extract. Here is a sample of the proc that I wrote:

SELECT ISNULL(CQN.AssesseeEmployeeNo, 0) AS AssesseeEmployeeNo, ISNULL(CQN.AssessorEmployeeNo, 0) AS AssessorEmployeeNo,

ISNULL(Common..PERSON.REPORTS_TO_SEQ_NR, 0) AS...

Hey Jeff

Thanks for the feedback, we took your advice and used the books online about the cross and it worked like a charm, it is however hardcoded but I will...

There are 64 questions, each question may contain only 2 answers (i.e. CategoryA = 64 and CategoryB = 64), as I showed in the small example. Maybe I am getting...