philippe pons
phpons at gmail.com
Thu Apr 2 14:39:37 CDT 2009
It seems there is nothing to download from codeplex! Philippe 2009/4/2 Heenan, Lambert <Lambert.Heenan at aiuholdings.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 > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >