Well, you are missing the '@' for email parameter for the second insert.

And I am not sure why @emailtable is defined in the procedure and you are using "select...

The execution of update statements are not evaluated left to right but as a batch after computations are complete which allows for them to be swapped.