Re: SQL statement is to large, and creates a error

jimi_xyz_at_hotmail.com wrote:
> So, do you recommend creating a kind of temp table, that contains all
> of the project ids?
>
>
> Frank van Bortel wrote:
> > Maxim Demenko wrote:
> > > jimi_xyz_at_hotmail.com schrieb:
> > >
> > >> NOTE: There is about 1884 values within the IN () function. AND..
> > >
> > >
> > >>
> > >> Any help/ideas will do.
> > >>
> > >> Thanks Inadvance
> > >> Jimi
> > >>
> > >
> > > Maybe this helps
> > > http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14200/expressions014.htm#sthref2245
> > >
> > >
> > > <quote>
> > > A comma-delimited list of expressions can contain no more than 1000
> > > expressions. A comma-delimited list of sets of expressions can contain
> > > any number of sets, but each set can contain no more than 1000 expressions.
> > > </quote>
> > >
> > > Best regards
> > >
> > > Maxim
> > And with reason, I'd say.
> >
> > Having 1000 (or more - as you have) elements in such an IN list
> > triggers the thought you are missing a table that can be referenced
> > through a foreign key.
> > More efficient than an IN list, too.
> >
> > So, rethink the design.
> >
> > --
> > Regards,
> > Frank van Bortel
> >
> > Top-posting is one way to shut me up...

IM sorry didn't mean to top post.

Jimmie Received on Thu Nov 03 2005 - 14:15:26 CST