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
Wayne Myers, MCSD
Senior Consultant
Forte' Incorporated
"The only things you can take to heaven are those which you give away" Author Unknown