>Hi,
>
>I have a place in the program where the SQL Select (that selects records for a Cursor Adapter) is built dynamically as follows:
>
>
>select * from MyTable where OrderNo in (Number1, Number2, .... )
>
>
>The part in parenthesis is built dynamically and the user can select pretty much any number of order numbers to include. So if the entire SQL Select becomes too long, it bombs. Any suggestions on how I could simplify this but still allow user to select any number of "orders"?
>
>TIA
The syntax for doing so would be a little adventurous but ... you can create a temporary table in SQL Server with the list of numbers, and have your main query use that as an IN SELECT target. That should be more optimizable than what you have.
Hank