When I run as a proc I now get this for table list output.

Thanks for the message.

First let me say this is a commercial software package, I DID NOT DESIGN THE DB.

Yes the WHERE clause represents the index (there is another...

I added the alias as you suggested, same exact result. While it certainly should be aliased I had a feeling doing so would not result in a different outcome. There...

Hmm. Are you certain? All the other tables move data ok. They all have the same exact rules. The statements are generated by a dynamic system I have been writing...

Tried this same result.

The NOT EXISTS option seems to have worked. I am working out a couple other things.

Thank you everyone.

Would love to. In fact I would kind of like to see it too!! 🙂 I could likely fix this if I did.

The query just runs indefinitely so the...

Why do the JOIN clauses seem weird and most useless?

And thank you for the suggestion I am about to test this. The statements are dynamically generated so this will take...

Can you give an example please? This is a NOT IN and the cast / convert is present because the two columns together are a unique index.

A join would...

I commented the actual list of columns for testing. It is not SELECT * in principal / production.

INSERT INTO [addb20].[Target_MergeAMD4_WithData].[dbo].[ConfigOption] ([Active], [ConfigOptionGUID], [ConfigOptionTypePropertyId], [ConfigOptionValue], [FKGUID] ,ImportIdentity, GUIDIdentity)

SELECT st.[Active],...

Have used the tool for years. Strange name I will give you that but it works great and has every option you can imagine.

http://www.dpriver.com/pp/sqlformat.htm

Solved in thank you thou.

+ ' AND (' + @Alias + '.SourceID <> ' + @Alias + '.DestinationID AND EXISTS (SELECT 1 FROM ETLCorrelation WHERE DestinationTable = ''' + @PKTableName...

I will give it a try thank you. AND I don't have to count I just need to know if the result is greater than 0. Basically true /...