I have a little problem that I couldn't seem to find an answer to merely by
searching the web.
I have created a stored procedure in MS SQL Server 2000, and I am trying to
set the sort order to ASC or DESC by an input parameter. I have tried the
different types of CASE sentences after the ORDER BY clause, but I am
Specifying an ORDER BY clause in the same manner is an easy task, but not
when it comes to the ASC or DESC clause.
Is there anybody who can help me?