Sean Lange (12/21/2012)

---

Excellent job posting ddl, sample date and desired output!!! I wish everybody would post their questions like this.

Here is one way to do this.

select * from #temp

where cCurrentGradeCode + cAnticipatedGradeCode <> '9999'

order by cStudentID