I want to make destination table's result from table-1

by il.king   Last Updated November 08, 2018 21:06 PM

table-1

Table-1

destionation table enter image description here subject:test subject field of table-1

score:Score field of table-1

Norm: Achievement field of table-1

%=rank as a percentage

If he is #4 ranked of 200 students, then ranking

for example student's rank 1 in 100 students so % has to equal 1

percentage is 4 / 200 * 100 = 2

DA: District Average which means the average of scores of specific year, grade and subject.

Tags : sql-server


Related Questions


creating index on big table(s)

Updated September 03, 2018 18:06 PM

Linked Server Error on SQL Agent Job

Updated March 16, 2016 08:02 AM