Good morning all.

I'm sure this is pretty simple, but i'm failing at the moment.

I want to run an insert sql script to insert new data into a table.

Here is a copy of my script so far.

This is where i get stuck... I only want records to be imported where the Prefix in SourceTbl is "A", and the fields "Key1" and "Key2" are not collectively already in TargetTbl.

I should probably explain that i already have an UPDATE statement to cater for records where "Key1" and "Key2" are collectively in TargetTbl. I wanted to use a MERGE statement, but due to the unchangeable compatibility level of our database, its not going to happen.

If someone could help or point me in the right direction, i'd greatly appreciate it!

Thank you all.

Practice doing a simple SELECT to verify you get the wanted rows:

WHERE SourceTbl = 'A'
AND NOT EXISTS
(SELECT * FROM TargetTbl as TT WHERE tt.key1 = st.key1 AND tt.key2 = st.key2)

You may also want to have a look at the MERGE statement.

Stolze, i cannot use the MERGE statement as the compatibility level of the database is too low, as previously stated.

JarlH, thanks for your help. I was only missing the 'EXISTS' or 'NOT EXISTS' section off my script, all working now, thank you.

Sorry, I didn't know what you mean by "compatibility level".