CLASS | STD | NAME | SUBJECT | PT1 | PB1 | PT2 | PB2 | 1 | ST1 | NITYA | ENG | 12 | 15 | 30 | 9 | 1 | ST1 | NITYA | HIN | 2 | 22 | 25 | 6 | 1 | ST1 | NITYA | MATH | 3 | 10 | 32 | 8 | 1 | ST2 | SHIV | ENG | AB | AB | 10 | 2 | 1 | ST2 | SHIV | HIN | 2 | 22 | 20 | 1 | 1 | ST2 | SHIV | MATH | 3 | 10 | AB | 5 |
CLASS|STD |NAME |ENG |HIN |MATH |T1 |ENG |HIN |MATH |T2 |T1+T2| |PT1|PB1 |PT1|PB1|PT1|PB1| |PT2|PB2|PT2|PB2|PT2|PB2| 1 |STD1|NITYA |12 |15 |2 |22 |3 |10 |64 |30 |9 |25 |6 |32 |8 |110 |174 1 |STD2|SHIV |AB |AB |2 |22 |3 |10 |37 |10 |2 |20 |1 |AB |5 |38 |75
Quote:Sir I am a beginner I am not getting any point, how to do this... Please help...
Quote:Now I want to use this as PIVOT TABLE as described below: - CLASS|STD |NAME |ENG |HIN |MATH |T1 |ENG |HIN |MATH |T2 |T1+T2| |PT1|PB1 |PT1|PB1|PT1|PB1| |PT2|PB2|PT2|PB2|PT2|PB2| 1 |STD1|NITYA |12 |15 |2 |22 |3 |10 |64 |30 |9 |25 |6 |32 |8 |110 |174 1 |STD2|SHIV |AB |AB |2 |22 |3 |10 |37 |10 |2 |20 |1 |AB |5 |38 |75
SUM('AB', 'AB', '2', '22', '3', '10')
select CLASS,STD ,NAME,SUBJECT,pt1,pt2,pb1,pb2,t1,t2,gtot from ( select class,std,name,subject,pt1,pt2,pb1,pb2,(pt1+pb1)T1,(pt2+pb2)T2,(T1+T2)Gtot )a pivot ( sum(Gtot) for subject in([Eng],[Hin],..) )pvt
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)