Retrieve only updated or changed records

pradeep_itguy · October 28th, 2004, 11:43 PM

Hi
I have a table in my DB and I am loading that table from the remote datasource every morning thru DTS package and I want to change that logic such that every morning it will pull only modified records and I load only modified records to table.

Please help me in this, I cannot do a replication because my programs wants that via DTS. Pleas help thanks.

It is not how much we do,
but how much love we put in the doing.

-Mother Theresa

jemacc · November 1st, 2004, 08:18 AM

You can use a query to compare the records that do not exist in one table and copy it to another
example:
[code]select * from tableA
where not exists (select * from tableB code]

or you can set a flag in the table 1 or 0 when a new records is added and only copy those records. when you copy the records reset the flag.

Code:

update tableA
set updated = 0
 where not exists (select B.customerid from tableB as  B where B.customerid=TableA.customerid)

Jaime E. Maccou
Applications Analyst

pradeep_itguy · November 4th, 2004, 06:55 AM

I am retrieving a record from the source and I have no control over that, Is there any mechanism in SQLServer like what we have in Oracle called "Materialized Views" which created will give only the updated or changed records?

It is not how much we do,
but how much love we put in the doing.

-Mother Theresa

jemacc · November 4th, 2004, 10:55 PM

Is there a datetime column or flag field you can identify the modified column?

Jaime E. Maccou
Applications Analyst