0 - 1 of 1 tags for update 7547 spool

Hello,
I'm running an update, and as I develop it, from updating everything incorrectly, to error 7547's, to spool space, and collecting stats on tables invloved, distinct, with and without qualify row_num, I get 7547 or a spool stll. Can someone please help me with this update statement.