Declare @studentnum varchar (9), @ course varchar (10), @ Achievement Tinyint, @ ClassOrder tinyintdeclare @pstudentnum varchar (9), @ allcourse varchar (60)
declare allachievement cursor for select studentnum, course, achievement, classorder from tempachievementwhere indate = convert (char (10), getdate (), 120) and achievement> 0order by studentnum, course
Open allachievement
