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. ......
October 9, 2007 2:36 AM
December 2, 2007 11:24 AM