[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