jwcolby
jwcolby at colbyconsulting.com
Thu Apr 2 14:45:07 CDT 2009
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 >