Hi I want to Append rows from 1 table to another where the data in a Varchar filed does not exist 95% of the data is already in the Target Table, and I only want to copy over the rows where that are missing.
If I delete several rows from the target table or modify the data in the spdesc column on several rows I get 0 rows Appended. Is there a better way to do this? -- spdesc is a Varchar field APPEND swap2 TO soapcode WHERE spdesc NOT IN (SELECT spdesc FROM soapcode) Thanks Marc
