Cursor 101- all my points
Posted on 2003-10-21
1 have 2 tables, scores & scorelements, used to track training. Scores has unlimited user records for each course, per 'comp_id'- ex- chapter 1 quiz. the 'comp_id' vary per course, but all i need is to check that each comp_id is completed per course.
ok- so usr2 shouldnt be returned becuase he has records for only for compid1- usr1 should be returned because he has records for all ids for crs1. this is why i think i need a cursor- but im new to them.
also, count(*) wont work because usr can have multiple records for each comp_id, users can retake the course as many times as needed.
ideal return would be (based on example above):