. . . "Is there a more automated way of building a table based on a SP like this (like a SELECT * INTO) ?Some of the tables have many columns, and it is very tedious to manually create tables and specify the data types for each column." .