> How to best implement ORDER BY of a query when the field by which to > order, is given as stored procedure input parameter?
If the data set returned by the procedure is not very large, return all relevant fields from the procedure and use order by in the query selecting from the procedure (it won't use indices, so it's only suitable for reasonably small number of records). Otherwise, I'd opt for EXECUTE STATEMENT, as Helen suggested. regards Tomasz -- __--==============================--__ __--== Tomasz Tyrakowski ==--__ __--== SOL-SYSTEM ==--__ __--== http://www.sol-system.pl ==--__ __--==============================--__
