Thanks for the reply. I guess the only way to find out is to actually try it.
Gonna let the forum know what my results are ... Speed wise, i figured an update stored procedure shouldn't take more than 5 seconds to run on 20,000 records.
If this works, then surely it's a good tips to use the temp table as a work around for calling alias in stored procedures ...