Arthur Fuller
artful at rogers.com
Thu Oct 30 18:25:06 CST 2003
How about an OUTER JOIN on the PKs, with an IS NULL criterion? That's about the quickest way I can think of, many times quicker than a NOT IN() for example. Arthur -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Martin Reid Sent: Thursday, October 30, 2003 1:18 AM To: dba-sqlserver at databaseadvisors.com Subject: [dba-SQLServer]Ideas comments HELP Heres the idea We have a hand held scanner which contains a table We link Said scanner to SQL Server If the table data on scanner is different in any way to the data in the same table on SQL Server we replace SQL Server table with the scanner table or just the different rows. Question 1. Whats the best way to do this? 2. Can this be done without pulling the table of the scanner? 3. Is there anyway we could create checksums for a table and compare them? Any one any clever ideas. Speed is a real issue here. Martin _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.530 / Virus Database: 325 - Release Date: 10/22/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.530 / Virus Database: 325 - Release Date: 10/22/2003