在SQL Server中使用case语句时，Order by子句出错

I have a stored procedure defined as below. When I execute it, I get an error and couldn't come up with a solution.I have a stored procedure defined as below. Whe