JMoss
jmoss111 at bellsouth.net
Fri Aug 27 12:22:26 CDT 2004
John, While not returning every 100th record, this will return unique records. The NEWID() function randomly sorts the input table INSERT INTO tmpCustomer (CustKey) SELECT CustomerID FROM Customers WHERE CustomerID IN (SELECT TOP 650000 CustomerID FROM Customers ORDER BY NEWID()) -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of John W. Colby Sent: Friday, August 27, 2004 10:39 AM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Every 100th record Gustav, I am working on a SQL Server database of about 65 million records. We need to pull a subset of those for doing counts of data in specific fields. Trying to do that analysis on the entire 65 million records just won't work at least in anything close to realtime. Thus we literally want to pull every Nth record. If we pulled every 100th record into a table that would give a sampling of 650K records to run this analysis on. That still won't be lightning fast but at least doable. John W. Colby www.ColbyConsulting.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock Sent: Friday, August 27, 2004 11:22 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Every 100th record Hi John > Does anyone have a strategy for pulling every Nth record? My client > wants to pull every 100th record into a dataset for analysis, to speed > things up I am guessing. To speed up what? Analysis on a sample only and not on the full set? If so, you could select by "Random Between 1 To 100" = 1. /gustav -- _______________________________________________ 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