Can Anyone send the sample Query of weighted sum method?

Following are the Query which fulfill your requirements just add your factors and run it.

select * from (
select Name,ContactNo,Email, TestMarks,cast((TestMarks/100)as numeric(18,3)) RatioTestMarks,ExpectedSalary,1-cast((ExpectedSalary/(select max(ExpectedSalary)+500 from CandidatesData where InitialInterview=1)) as numeric(18,3)) RatioExpectedSalary
,SecondInterview,cast((SecondInterview/100)as numeric(18,3)) RatioSecondInterview,HRInterview,cast((HRInterview/100)as numeric(18,3)) RatioHRInterview
,(0.25*cast((TestMarks/100)as numeric(18,3))) + 0.25*(1-cast((ExpectedSalary/(select max(ExpectedSalary)+500 from CandidatesData where InitialInterview=1)) as numeric(18,3)))+0.25*cast((SecondInterview/100)as numeric(18,3))+(0.25*cast((HRInterview/100)as numeric(18,3))) FinalRatio
from CandidatesData where isnull(HRInterview,0)> 0)tbl order by tbl.FinalRatio desc

2 Replies

Know the answer? Post it — somebody with the same question will find it here.