>I have heard it argued that it's not a good idea to do ORDER BY's in a stored proc or client side SQL because it can slow things down.
>I know I can sort the data any way I want in the UI, but does anyone agree with this POV?
>
>Thanks
I see no problems doing order by in your query. I've seen the order by done somewhat dynamically so you can pass in a parameter to tell you how to order it.