A problem with this. The #tempfile goes from main SP to called SP. To add on the company name I do a select with the #tempfile and the company file. Now the results are in a 2nd file, #tempfile2. Isn't the #tempfile2 local to the SP that made it so the main SP can't use it? The #tempfile that was passed in still hasn't been altered.

Are you doing something else in your routines, such as updating existing fields on the passed in table instead of getting the data through select/joining two files? So I might make a blank field for the company name in the main SP and then pass the #tempfile to the 2nd SP to fill the company field in?