Re: Flexible ORDER BY based on parameter in UDTF

[Arco Simonse <arco400@xxxxxxxxx>]

If all else fails then dynamic SQL would be the rescue here, but if
possible I would prefer a static solution.

Op dinsdag 27 december 2016 heeft <dlclark@xxxxxxxxxxxxxxxx> het volgende
geschreven:

> "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx <javascript:;>> wrote on
> 12/27/2016
> 11:09:08 AM:
> > Is it possible use a variable or parameter value for setting an ORDER BY
> in
> > a UDTF?
>
>         I would do it with dynamic SQL.
>
>
> Sincerely,
>
> Dave Clark