I want to set up a stored procedure where the data is ordered by column according to user input, i.e.<pre class="ip-ubbcode-code-pre">GetSomeData(@SearchPhrase ...

If you are a SQL programmer, learning recursive SQL techniques can be a boon to your productivity. A recursive query is one that refers to itself. I think the best way to quickly grasp the concept of ...