Forums
This topic is locked
ASP SQL Query
Posted 08 Nov 2006 16:36:15
1
has voted
08 Nov 2006 16:36:15 Steve Bedder posted:
Hi,I've got a SQL database that contains the following columns - Course, January, February, March, April etc plus other columns.
There will be multiple records for the same course name e.g.
January February March April
course1 10-13
course1 20-21
course1 1-5
course2 13-12
course2 9-6
On my page, I want to be able to show the following:
January February March April
course1 10-13 20-21 1-5
course2 13-12 9-6
I've been trying for days to try and get this to work, I can get somewhere close, but not the whole way.
Anyone any advice or suggestions?
Thanks in advance
Steve