SQL SERVER Stored Procedure (SP): Parameterized ORDER BY without Dynamic-SQL - Example 1

SQL Server Stored-Procedure performing a parameterized ORDER BY operation without using Dynamic-SQL
The Microsoft SQL-Server Transact-SQL (T-SQL) stored procedure (SP) or query presented here can accomplish an interesting task: performing a parameterized ORDER BY without using Dynamic-SQL to do so. This method builds on some other examples I have provided demonstrating various SET-BASED