If this is SQL Server, you can pass xml and join against it. Take a look at OPENXML.


>Hi
>
>I have a view (product table) from which users can select any number records on which to summerize transactions within a given month.
>
>I can create a SQL-passthrough query to handle this using INLIST but as the number of selections gets up the size of this becomes unmanagable.
>
>Can I pass a cursor with my selections back to the remote database so I can use WHERE IN? Alternately, can I pass an array a parameter in a remote view?
>
>Regards
>Geoff Scott