Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Cyclonik
Posting Yak Master
114 Posts |
 Posted - 2001-07-11 : 16:01:04
|
| Ok here is the situation.I have tests that are stored in 2 tables the first , tests, is as follows test_id, lanid, tester_id, testdateand a second table that holds the score: test_scores monitor_id, question_id, score (1-5)a score of one on a question is considered an exception.what i need to do is count the number of exception free tests for a user (lanid),so a monitor with an exception is only counted once per test. up until now i have been calculating this outside of the database. i want to do it inside a stored proc without a cursor. Might anyone suggest a way if possible to do this?Thanks Christian-=:SpasmatiK:=- |
|
|
|
|
|
Tricky Query?