PRSQL9103007: Running a Query with an IN Clause GP-Faults SQL ID Number: Q70827
1.10 OS/2 buglist1.10
Summary:
PROBLEM ID: PRSQL9103007
SYMPTOMS Running a query with an IN clause GP-faults SQL SERVER.
CAUSE This problem occurs if there are more than 250 parameters in the IN clause.
RESOLUTION Place the parameter values into a table, and run the query against this table. For example:
Select @pb from table where @pb in (select col1 from newtab)