I figured it out

eu.userid = ua.id

needed to be

eu.userid = ua.userid

I am going to start using Merge for a few different tasks I have.

thanks a lot Polka Dot for the DDL and DML. This is definitely the right kind of solution for me. Unfortunately this code fell a little short. ...

thanks, that worked. I dismissed trying that because I want more than zero rows. I need to stop listening to my gut instincts, when it comes to sql,...

I took the time to create that scenario because I am asking for help so I wanted to be specific as possible. I guess that backfired huh.

Here is what...