I have created a table called MyEmployees with ManagerID,ContactID,etc.,.. fields.
Also i created another table ManagerAndContact with Only ManagerID and ContactID as fields.
Now what i need is, whenever am inserting a new row in MyEmployees table, the corresponding ManagerId and ContactId should be inserted into the second table - ManagerAndContact using trigger.
Note: the id's are not in ascending or descending order. The data to the MyEmployees are fetched from a text file with random values for id's(managerid,contactid) Ex: 1029, 1019, 1044, 1024. ......
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!