David McAfee
davidmcafee at gmail.com
Thu Nov 15 13:27:48 CST 2012
I don't think so. I run large manual queries like this.
I update a table yesterday with several hundred IDs in an in clause.
Can you dump the IDs into a temp table or table variable and select from or
join to the temp table?
On Thu, Nov 15, 2012 at 11:06 AM, jwcolby <jwcolby at colbyconsulting.com>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.
>
> --
> John W. Colby
> Colby Consulting
>