Brandon Goodin wrote:

I see. The question here is whether this is a common database issue
and if it should be supported. However, it does not seem to be a
common issue and there are ways to work around this. My other thought
is.... why do you have over 250+ IN parameters?



My guess: they have a large table with a foreign key. When they do a select for this large
table, they also want to obtain the parent table values specific only to *that* resultset.


So we have:

ChildTable
ID         COL1            COL2                FK_ID
------      --------         --------              ----
001         ABC            ASD                    1
002         EDF            ASE                     1
003         EDW            746                     2

(SELECT * FROM ChildTable)

Now they want to do this:

SELECT * FROM ParentTable where
FK_ID IN ('1', '2')

In two round-trips, you have Master-detail.

Reply via email to