There are several methods to implement the dynamic ordering of result returned by SQL query. The examples of stored procedures below use the Microsoft's demo database AdventureWorks.

USE AdventureWorks
GO

How much of disk space is used by tables?

What is SPM

SPM is the macroprocessor to develop stored procedures, functions, triggers and views. SPM is able

What is DBStressor

DB Stressor is the tool to perform the tests of your databases productivity and stability. DBStressor simulates the multi-user concurrent work, collects and stores the performance statistics and represents the results in the preprocessed view.