Hi @Christopher Jack ,
The image about the issue is broken that we couldn't see the error message.
If possible could you help provide the simple data of the two table?
I just did a simple test as shown below.
Also if you may directly use insert into with t-sql to add all values of a table into another table.
If I misunderstand your needs, please incorrect me and give us more details.
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues October