Dear Friends,

Please help me to find the solution for the below data. I am using MSAccess Database and Active Server Pages.



A table consists of few records, given below, I have to get output in a single row.

ClassName Date Time Description
---------- ------ ------ -----------
K-11 10/10 08:30 Exam Hall
K-11 10/10 10:00 PGP Room
K-11 10/10 11:00 FPM Room
K-12 10/10 10:00 Audioturium


Output I should get as below using single sql command

ClassName 08:00 08:30 09:00 09:30 10:00 10:30 11:00
--------- ---- ----- ----- ---- --- ---- ----
K-11 08:30 10:00 11:00

Thanking you,

With Regards,
Asif