I have Two Tables.
1. ELR Table ( ProductID, ProductName, Date of Expire) - Updates every day.
2. StoreData (ProductID, ProductName,Date of Manufacturing,DateofExpires,TotalProducts and Status)
My Requirement is to get the New data from ELR Table to to StoreData.
Example:
ProductA is already existing in StoreData and status is closed. So, tomorrow, if productA comes in ELR Table, ProductA from ELR table should copied into Storedata.
Is it possible?
1. ELR Table ( ProductID, ProductName, Date of Expire) - Updates every day.
2. StoreData (ProductID, ProductName,Date of Manufacturing,DateofExpires,TotalProducts and Status)
My Requirement is to get the New data from ELR Table to to StoreData.
Example:
ProductA is already existing in StoreData and status is closed. So, tomorrow, if productA comes in ELR Table, ProductA from ELR table should copied into Storedata.
Is it possible?