[AccessD] Strange limit

John,

You have 2 different fields in your SQL
Column_Number and Column_Name -- is that an issue?

'''''''''''''''''''''''''''
(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'))
'''''''''''''''''''''''''''

On Thu, Nov 15, 2012 at 3:29 PM, RANDALL R ANTHONY <RRANTHON at sentara.com>wrote:

> D'OH, just left out the query...
> select * FROM tablename
> where columnname in
> ('', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '',
> '', '', '', '', '', '', '', '', '')
>
> Just ran this straight sql query, notice 27 columns (thereabouts), IIRC in
> SQL the parameter limit is something like 64K.
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com [mailto:
> accessd-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence
> Sent: Thursday, November 15, 2012 2:42 PM
> To: 'Access Developers discussion and problem solving'
> Subject: Re: [AccessD] Strange limit
>
> 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
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> -------------Disclaimer---------------
>
> This electronic message and its contents and attachments contain
> information from Sentara Healthcare and is confidential or otherwise
> protected from disclosure. The information is intended to be for the
> addressee only.
>
> If you are not the addressee, any disclosure, copy, distribution or use of
> the contents of this message is prohibited. If you have received this
> electronic message in error, please notify us immediately and destroy the
> original message and all copies.
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>