BTW I am doing this so I can clean up the nvarchar's, and avoid doing this in the Join's and the where, so the data will match what is needed. Interesting.. changing the three sql statements, (that use this table), with all the called functions to clean up the code... takes longer with the addition of writing the data into this temp table. So back to the drawing board on how to improve the 10 min run time. (we want to run this data load every 20 min)