I have a stored procedure that I would like to order by the order of the parameters it takes in starting for current item number 1, prior item number 1, current item number 2, prior item number 2, and so on.
currently I am ordering it by:
among other fields, but I would like to replace the part above with the parameters 1 through 5 (current and prior).
Is this possible?
Please see the attached stored procedure for reference.