[dba-SQLServer]Re: Ideas comments HELP

Martin,

Add a datetime column for ModifiedDate.

Then do a query something like this:

SELECT tblTable.TableID, tblTable.TableName, tblTableField.TableID
FROM tblTable LEFT JOIN tblTableField ON tblTable.TableID = 
tblTableField.TableID
WHERE (((tblTableField.TableID) Is Null));

except join on the PK and the modified date.

tblTable would be your Scanner table
tblTableField would be the SQL Server table


Robert

At 10:37 AM 10/30/2003 -0600, you wrote:
>Date: Thu, 30 Oct 2003 09:18:13 -0000
>From: "Martin Reid" <mwp.reid at qub.ac.uk>
>Subject: [dba-SQLServer]Ideas comments HELP
>To: <dba-sqlserver at databaseadvisors.com>
>Message-ID: <011701c39ec6$beb6cc70$9111758f at aine>
>Content-Type: text/plain;       charset="iso-8859-1"
>
>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