Thanks Lynn,I ll do it

am trying to display the student attendance, for example, the student absentees list in daily,weekly,monthly and yearly basis

relational only

I dont understand......what is relational and cube

thanks for ur response, I tried like this

select COUNT(Attendance.studentid) as Absentees,

Sections.Max-count(studentid) as Presentees,

Students.Gender as Gender

from Attendance

inner...

thanks Daniel Bowlin for ur response, I just tried my code again by using the '&', its working now

declare @minmarks int

select @minmarks=minmarks from table2

select (case when sum(convert(int,marks)) >= @minmarks then 'Pass' else 'Fail' end) as Result

from table1

GROUP BY StudentId,SubjectId,ComponentId

am getting the result, thanks

thanks Pablo (Paul) Berzukov, for ur response

of course am doing, I need some idea, how to do that,thats wat askin here

fine I'll do, thanks

how can we write the same query using else condition

you are awesome anthony.....thanks alot

in that query if I give 2 it shows nothing, what can I do to display both pass and fail

thanks anthony for ur kind, the problem is am a newbie to sql I dunno how to take the DML. the report is working now, I found the problem, I'll...

ya its working, I think the problem is when joining the tables, here I've to join more than 3 tables, I'll check it....thanks for ur respone anthony

is it....wait I'll check