update output into table variable

[glamb]

Question:
Given:
1. a stored procedure that updates multiple tables.
2. declare a table variable for the output clause of the first updated table
3. given that you want the same output fields for the second updated table (the first and second tables have common fields)
4. Can you use the same table variable for the output of the second table, ie, if it can be used, is the output data appended to the table variable or overwritten?

 

[simian336]

Do you have an example that might help visualize your problem.

Simi