1 Reply
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Problem With Rank()
Hi...
In my database i have tables like
tblsubject(sid,sname),tblexam(eid,ename),tblexaminf0(exid,eid,maxmarks,minmarks),tblprogress(pid,exid,seuredmarks)tblstudadmisform(studentid,class,name,fname)
i want to display ranks of the sutdents i wirte query like
ALTER PROCEDURE [dbo].[Sp_getProgress]
@studentid varchar(50),
@examTypeId int ,
@ScId int,
@BrId int
as
select regd_no, SubjectName,CONVERT(int,MaxMarks) as MaxMarks,CONVERT(int,SecuredMarks) as SecuredMarks,ei.examId,ExamType,minmarks,--sa.Class_admission,ei.examinfoId,
case
when CONVERT(int,SecuredMarks)
TrinityPosted Oct 10, 2009, 4:40 PM