I have a stored procedure that simply runs a select from a table and orders it. I am passing a variable to this procedure which will determine how this data is ordered. When I use the variable in the order by clause it tells me its not allowed. Does any one know a way of getting round this problem.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
SQL Query Trouble
- Thread starter 08091979
- Start date
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question