Thanks everyone for  their response. I was able to get it going with your help. The first answer had issues as I was using reserved words evidently for my column...

Phil,

Thanks for your reply. I'm not clear on what you are suggesting. The only thing that links the two databases is the custid and custcode values. Based on that I...

I suspected that was the Case. Thanks for the reply

I tried the code sample below and it prints back the list of Update statements properly. When I copy and paste this into a SQL Window it fails on the...

Thank you everyone for your help. The application is static so I don't have to worry about the table structure changing or new tables being added. I think I can...

Thank you for all the suggestions. I tried the Fetch next option and the Count(1) but the result was the same. Also, I did print out the values for the @ClientID,...

Thanks Steve. The problem I didn't make clear was that table 1 and table 2 are in 2 different databases. Thus the PK's (ID & Contact#) are different for the...