Sean Lange (12/21/2012)

---

Here is another way.

select t.* from #temp t

join #temp t2 on t.cStudentID = t2.cStudentID

where t2.cCurrentGradeCode <> '99' or t2.cAnticipatedGradeCode <> '99'

order by t2.cStudentID