jwcolby
jwcolby at colbyconsulting.com
Thu Apr 2 13:51:03 CDT 2009
Charlotte, You could do that. But I need it to show me steps of X PKID. Perhaps every 1 meg PK over 50 megs of records. Like that. John W. Colby www.ColbyConsulting.com Charlotte Foust wrote: > 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 >