Check for Empty Table
Posted: Fri Jul 17, 2009 3:52 am
Hi All,
I have a source table and target table ,i want to transfer some records into target based on records exist in target table i.e. if target table is empty then i want to transfer all the records from source and if target table is not empty , i want to transfer the records from source which are not in target and updated records from source .
Thanks in Advance
I have a source table and target table ,i want to transfer some records into target based on records exist in target table i.e. if target table is empty then i want to transfer all the records from source and if target table is not empty , i want to transfer the records from source which are not in target and updated records from source .
Thanks in Advance