[AccessD] http://northwind.codeplex.com

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