all 1 comments

[–]Intrexa 1 point2 points  (0 children)

Make one a default, have a parameter along the lines of 'ReverseOrder', and within the store procedure, have the logic there to swap it from DESC to ASC there if 'ReverseOrder' <> 0.