I have a master table in which more than 25 foreign keys are there pointing to different lookup tables.
For eg, I have a table called StudentMaster with
University (FK) etc..
Now I am importing data from a temporary table and they have provided the values instead of codes in the Foreign Key values. Now I need to write a script to import these data into my table. When importing data if any lookup value found I need to insert them into the lookup table and then insert the master data along with new lookup codes.