firstQuery.sql

SELECT	(sr.studentResponseValue * cw.categoryWeightValue) AS weightedResponse
	, cw.occupationalCategoryID AS cID
	, iqo.interviewQuestionOptionID AS oID
FROM dbo.StudentResponseTable AS sr
	INNER JOIN dbo.InterviewQuestionOptionTable AS iqo
		ON (sr.interviewQuestionOptionID = iqo.interviewQuestionOptionID)
		AND (sr.studentID = @studentID)
		AND (iqo.interviewQuestionOptionActive = 1)
	INNER JOIN dbo.CategoryWeightTable AS cw
		ON (sr.interviewQuestionOptionID = cw.interviewQuestionOptionID)

secondQuery.sql

SELECT	studentID
	, occupationalCategoryID
	, SUM(weightedResponse) AS weightedResponseTotal
FROM dbo.weightedInterviewResponsesView
GROUP BY studentID, occupationalCategoryID
HAVING studentID = @studentID
ORDER BY weightedResponseTotal DESC