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-11-09 : 09:46:05
|
Travis writes "I was wondering how I could create a table of contents based on the row 'Code'. I have 1 table, which has 50 different alphanumeric entries in the row 'code'. I need to set up something like this,
http://demoroom.physics.ncsu.edu/html/mechanics.html
The only way I can think of doing it, is by creating multiple recordsets and quering the SQL database about 50 times, each time with something like "select * from dbo.mech where code like '1a%'", Then, '1b%' and then '1c%'.
If there was a way to have the results given to me with one querry and all I have to do is place the statement where I want those particular results, I would be set.
Thanks in advance,
Travis" |
|
|
|
|
|
Multiple Select Statements