t-sql problem - SQL Server Forums

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

Transact-SQL (2005)

t-sql problem

Author

Topic

souravray79
Starting Member

11 Posts

Posted - 2007-08-20 : 07:32:50

studnet table...

fileds are...Id,name,math,physics,chemistry marks,percentage,grade

percentage & grade will automated field

if percentage is more than 60 then the grade will be 'A'

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-08-20 : 07:46:43

Dupe http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=88078

E 12°55'05.25"
N 56°04'39.16"

souravray79
Starting Member

11 Posts

Posted - 2007-08-21 : 07:20:00

plzzz read this problem properly

table student
field
stu_id,stu_name,math_marks,phy_marks,che_marks,Aggregate,grade
marks & Aggregate must be calculated filed and dependened on math,phy,che marks....
means....if i put integer value in fields math,phy,che then the aggregate field will be automallically calculate the percentage of these three marks and if the aggregate is more than 60 then the field garde will be shown 'A' in the same table

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-08-21 : 07:22:46

Asked and answered here
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=88078

E 12°55'05.25"
N 56°04'39.16"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources