Hi I have one requirement as follows.
Two tables Source and Target table.And need to update or Insert into target table i,e A-->B.
I have an column as date in A table,need to update or insert to table B with condition as
If B.date is < A.date then update
If B.date >= A.date Ignore it
If new record then insert
Please let me know how to implement this in Merge statement
the merge statement is explained in detail at this page MERGE
Best Regards, Guy Przytula
Database Software Consultant
Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
Information Server Datastage Certified http://www.infocura.be