[AccessD] Strange limit

Jim Lawrence accessd at shaw.ca
Thu Nov 15 13:42:13 CST 2012


Or is it just stopping at the OR clause?

Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Thursday, November 15, 2012 11:06 AM
To: Access Developers discussion and problem solving; Sqlserver-Dba
Subject: [AccessD] Strange limit

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

Reality is what refuses to go away
when you do not believe in it

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list