Stuart McLachlan
stuart at lexacorp.com.pg
Thu Nov 15 15:49:59 CST 2012
Quotes around Column_number values? Don't tell me column Column_number stores char
values :-(
--
Stuart
On 15 Nov 2012 at 14:22, jwcolby wrote:
> sorry, the second in() should also be in column_number and is how I got around the limitation.
>
> John W. Colby
> Colby Consulting
>
> Reality is what refuses to go away
> when you do not believe in it
>
> On 11/15/2012 2:06 PM, jwcolby wrote:
> > I am running the folliowing query:
> >
> > SELECT Column_Number, Column_Name
> > FROM _DataDB101.dbo.DB101_ConsumerLayout
> > WHERE (Column_Number IN ('241', '54', '64', '132', '191', '186', '133', '63', '139', '185',
> > '129', '151', '201', '147', '127', '113', '261')) OR
> > (Column_Name IN ('145', '141', '187', '52', '122'))
> >
> > Notice that I am asking for about 22 values in an In() clause. SQL Server is cutting it off after
> > the 17th value returned.
> >
> > I never knew there was such a limit though of course there would be some limit. 17 is rather small.
> >
>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>