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-02-15 : 18:28:54
|
| I am having some difficulties finding a structure that makes sense for a scorecard i'll explain the dataa recursive users table already exists holding the lanid/manangerid'si have a testee (lanid)a tester (manangerid)Q1 ..Q10 (criteria) values can be 0 to 5(notes) any notes on the scorecard2 date fields one for when the record was entered and one for testing date (date) (monitordate)ppl are tested/scored many times a month by any number of managersi need to be able to get average scores by question, by lanid, by managerid as well as numbers of 1 scores by lanid etc etcthis is structure i have pondered using{table questions qid questions}{table User_question_idx monitor_id (generated somehow) qid lanid mangerid score}{table Notes monitor_id notes} then maybe a date table{table Dates monitor_id date monitor_date}I want to make sure i set this up right so i can generate the reports etc i need to. Maybe i am totally off. I am hoping someone can enlighten me.ThanksChristian-=:SpasmatiK:=- |
|
|
|
|
|
Trouble Structuring this data