jwcolby
jwcolby at colbyconsulting.com
Thu Nov 15 13:22:18 CST 2012
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.
>