Can you show us the some sample data and the required output from the update query... I'm sure there's a way to avoid the spool altogether.