Use top 1 clause in your sub query to restrict one record at a time Currently your query are like this
SET @Course85=(SELECT CourseName ....)
SET @College85=(SELECT CollegeName FROM CollegeMaster ....)
SET @InspectionDate85 = (SELECT ...)
Change these to by adding Top 1 in each query
SET @Course85=(SELECT Top 1 CourseName ....)
SET @College85=(SELECT Top 1 CollegeName FROM CollegeMaster ....)
SET @InspectionDate85 = (SELECT Top 1 ...)