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 |
|
freemefast
Starting Member
1 Post |
 Posted - 2010-03-13 : 15:53:48
|
| Apologies if this is the wrong section to post or question has been answered before (I did run a search but it returned nothing)Hi,I am using sql server manager and want to calculate the weighted score of pupils exam and coursework marks.I figured I would have; -A coursework mark field (%)-Then what percentage of the final mark it is worth say 65%-A exam mark field (%)-What percentage of the final mark it is worth say %35-A weighted score field-Whether it is a pass or failCould you please tell me the formula/code for inputting this into my view? I have looked around the web but not found a clear answer.Thanks in advance,F |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Weighted score formula for views