connecting multiple table records and display on o

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.

All Forums

SQL Server 2005 Forums

.NET Inside SQL Server (2005)

connecting multiple table records and display on o

Author

Topic

raokikun
Starting Member

8 Posts

Posted - 2011-08-29 : 02:48:05

this are the details im gonna use

P_ID (a primary key)
student number
full name or firstname,lastname? (which is better)
year level
semester
course
subject code
subject description
grade
remarks

my system would be aimed to.. display the current grade of the student for example he is 4thyear and in semester 2 right now.

then there will be a button or any step that would display all his grade starting from 1st year sem1,sem2 up to his present grade

is it possible. can anyone help me? it will be a great help

feel free to give hints,tips and advice regarding database making

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-08-29 : 07:21:30

something like


select *
from
(
select row_Number() over (partition by fullname,course order by semester desc) as seq,columns..
from table
)t
order by fullname,course,seq

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

jassi.singh
Posting Yak Master

122 Posts

Posted - 2011-10-08 : 09:48:32

Hi, You can make a simple modification in previous message query i.e. instead of including fullname in partition by clause use studentnumber column of your table

Please mark answer as accepted if it helped you.

Thanks,
Jassi Singh

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-10-08 : 09:57:27

quote:
Originally posted by jassi.singh

Hi, You can make a simple modification in previous message query i.e. instead of including fullname in partition by clause use studentnumber column of your table

Please mark answer as accepted if it helped you.

Thanks,
Jassi Singh

what difference does it make?
Also whats the purpose of opening a thread now after almost 2 months?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources