I think the approach i have just stated is not proper actually. Suppose the user wants to see  all the marks of a particular student.  If the student was Absent...

k sorry for the delay everyone. I hope i can still get some precious inputs from you all.
k i have never used constraints in my database before, therefore this...

I was thinking of using a text box for marks , one radio button for Present and another for Disallowed. And then to save the marks in the table ,...

NO its not homework..(if u follow my posts u will realise it)

I used pivot query to get the results .

Select * From

(Select subject_id,student_pk, grade_id , marks...

its showing correct value for 'no of duplicates' but not for 'no of applicants'. in fact its repeating the same value in both the fields.

got it!

SELECT scholarship_id , Count(Distinct student_fullname ) as [No of students]

FROM Students

Group By scholarship_id

yes count the distinct studentnames and group by category. i want the result to be like this

no . | ...

oh yes... i need to count the no of distinct student names in each category. actually it should have been scholarship)id and not category.

i tried that query because it seemed...

thanks. i have tried this but i am not getting the student count just the scholarship_id

SELECT scholarship_id, Count(Distinct(scholarship_id)) as [Count]

FROM Students

Group By scholarship_id

what should my answer be if the question is " which algorithm are u using"? (impressive answer)

i think i am looking for this answer

http://sqlserverplanet.com/optimization/sql-server-join-algorithms

i am not trying to determine anything here. just wanted to know the algorithm used here. its like i have a give presentation on my application. so doing some...

So what am I supposed to do?