Manishreya
Programmer
I am using sql 7.0
I want to use cross tab for one of my table
I have data for perticular Student
Example
StId Degree
1 Bs
1 Ms
1 Phd
1 Diploma
From educate table
I want to disply as
StId D1 D2 D3 D4
1 Bs Ms Phd Diploma
How to do this as I can not use Sum as the fielddatatype is Varchar
Can any one help to solve this problem
Thanks
ManiShreya
I want to use cross tab for one of my table
I have data for perticular Student
Example
StId Degree
1 Bs
1 Ms
1 Phd
1 Diploma
From educate table
I want to disply as
StId D1 D2 D3 D4
1 Bs Ms Phd Diploma
How to do this as I can not use Sum as the fielddatatype is Varchar
Can any one help to solve this problem
Thanks
ManiShreya