Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-09-16 : 12:37:37
|
David writes "Dear Sean,
I am trying to find the EASIEST way to return these values in this order:
9:00-4:30
9:00-12:00
1:30-4:30
for a conference management application. Essentially, a co-organizer will enter data into a web based form that enters into the "Info" table the time they would like to meet.
From there the data is delineated into two tables (Contact and Support) whch are used to return the aggregated meeting times of all the co-organizers into a combined agenda separated by day.
The problem is that I cannot get the above mentioned values to return in that order. I have tried to edit my SQL query to ORDER BY every column in the table, but no luck. ORDER BY in the TIME column returns 1:30, then 9-4:30, then 9-12. Should I give the input form buttons different values (like 1, 2, 3 instead of 9:00-4:30)and use another reference/temp table to aggregate, order the data and give it the proper display values? If I did do this, any suggestions on the best way to do it?
Or am I totally off base? Do you recommend another solution?"
|
|
|
|
|
|
Returning rows in a specified order