>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?

What I would do, is create ALL the fields I will need in the initial temp file... then, susequent SP's can just add this data to the existing records.

BOb