[AccessD] Count of records in PK range

...Drew? ...is that you Drew?

William

--------------------------------------------------
From: "Max Wanadoo" <max.wanadoo at gmail.com>
Sent: Thursday, April 02, 2009 4:00 PM
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Subject: Re: [AccessD] Count of records in PK range

> Yes, but the question is surely "Does it have an intrinsic meaning" to 
> which
> the answer should be no. That does not imply that it has no meaning
> whatsoever, within a programming sense.  To the End User they have no
> meaning.  To the programmer every "object" (in its broadest sense 
> possible)
> has meaning.
>
> Am I right?
>
> Max
>
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
> Sent: 02 April 2009 20:45
> To: Access Developers discussion and problem solving
> Subject: [AccessD] Count of records in PK range
>
> ROTFL.
>
> They are sequential, and they have no meaning in my databases. And even 
> here
> all they mean is that
> they exist.
>
> John W. Colby
> www.ColbyConsulting.com
>
>
> Heenan, Lambert wrote:
>> Always assuming of course that your PK is something sequential. Which
> opens up that age old topic "Should Primary Keys have any meaning?"
>>
>> Who said that?
>>
>> Lambert
>>
>> -----Original Message-----
>> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust
>> Sent: Thursday, April 02, 2009 2:08 PM
>> To: Access Developers discussion and problem solving
>> Subject: Re: [AccessD] http://northwind.codeplex.com
>>
>> Maybe this is too simple, but wouldn't you just select Count(PKID) Where
> PKID less than or equal to PKID Z and Greater than or equal to PKID Y?
>>
>> Charlotte Foust
>>
>> -----Original Message-----
>> From: accessd-bounces at databaseadvisors.com
>> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
>> Sent: Thursday, April 02, 2009 10:33 AM
>> To: Access Developers discussion and problem solving
>> Subject: Re: [AccessD] http://northwind.codeplex.com
>>
>> I need to get a count of records in a PK range in SQL Server.  For 
>> example
> I need to know that there are X addresses between PKID Y and PKID Z.
>>
>> Any idea how to do this in tsql?
>>
>> John W. Colby
>> www.ColbyConsulting.com
>>
>>
>> Salakhetdinov Shamil wrote:
>>> Cross-posted in dba-VB and AccessD
>>> ===
>>>
>>> Hi All,
>>>
>>> Northwind.NET project has got the new version of publicly available
>>> source code today at
>>>
>>> http://northwind.codeplex.com
>>>
>>> This code is a result of the first week of SCRUM team work.
>>>
>>> Please download the code, try to run it, join dba-VB discussion...
>>>
>>> Stay tuned for the next versions of code planned to be released
>> regularily every one-two weeks...
>>> Thank you.
>>>
>>> --
>>> Shamil
>>>
>>>
>>>
>> --
>> 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
>>
> -- 
> 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
>