IF NOT EXISTS (SELECT * FROM REF_LINK_TABLES WHERE Table_Name = 'VW_CONTRACT_ALLOWANCE' AND CustomisationID = 999) BEGIN INSERT INTO REF_LINK_TABLES VALUES ('VW_CONTRACT_ALLOWANCE', 999, 'DT_CONTRACT', 'DT_ALLOWANCE', 0, 1); INSERT INTO REF_LINK_TABLES VALUES ('VW_CONTRACT_DEDUCTION', 999, 'DT_CONTRACT', 'DT_DEDUCTION', 0, 1); INSERT INTO REF_LINK_TABLES VALUES ('VW_CONTRACT_BENEFIT', 999, 'DT_CONTRACT', 'DT_BENEFIT', 0, 1); END