Microsoft KB Archive/70827: Difference between revisions
From BetaArchive Wiki
(importing KB archive) |
m (X010 moved page Microsoft KB Archive/Q70827 to Microsoft KB Archive/70827 without leaving a redirect: Text replacement - "Microsoft KB Archive/Q" to "Microsoft KB Archive/") |
(No difference)
|
Latest revision as of 19:29, 12 August 2020
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)