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