Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Order by and parameters
Message
General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Title:
Order by and parameters
Miscellaneous
Thread ID:
00727721
Message ID:
00727721
Views:
33
Can someone tell me how one used parameters in the order by clause to get some dynamic ordering without dynamic query building?

when I use:
group by username
order by @sortFld
I get:
variables are only allowed when ordering by an expression referencing a column name.

Should I use case structures in order by clause?
I've had problems with that in context of group by

or a if structure?

TIA
Next
Reply
Map
View

Click here to load this message in the networking platform