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-10-20 : 15:36:15
|
Lisa writes "I have a complicated query that I need to change according to user input. However the only thing that will change is the ORDER BY clause (users choose how they want the data sorted) so I would like to change it dynamically rather than repeating my select query 10 times in my stored procedure. I am using Sybase and I can not simply insert a variable into the ORDER BY clause. I read the article Running Dynamic Stored Procedures but this does not work with Sybase--do you know of a method that will work with Sybase?
Thanks a lot!" |
|
|
|
|
|
Varied ORDER BY in Sybase