I have four tables as follows in the attached image
The shipment table gets imported from another database daily.
I need a stored procedure/trigger that when records get added to the shipment table daily that it must check to see if there is an Asset.
If there is an asset then add the following record in the AssetHistory table which copies Asset ID, [Store #], and [O Tracking] into AssetHistory table. If there is no asset then do nothing. How do I go about accomplishing this task?