Microsoft KB Archive/70827

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)