Erwin Craps
Erwin.Craps at ithelps.be
Sun Nov 23 14:31:59 CST 2003
Martin, Your question is not very clear to me. What is it that you want to do? I don't see what the prob is with "only" 50.000 records. Erwin -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Martin Reid Sent: Sunday, November 23, 2003 9:03 PM To: dba-sqlserver at databaseadvisors.com Subject: [dba-SQLServer]Large recordsets I have to return perhaps in access of 50,000 records for use in Access. Linked to SQL Server 2000 What would be the fastest approach to take. Comments appreciated. Yeah I know the obvious, filter them first. But for the moment I am not allowed. to. Martin _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com