Home Forums SQL Server 2008 T-SQL (SS2K8) Outputting Sproc result set to a new physical table RE: Outputting Sproc result set to a new physical table

  • GilaMonster (8/3/2015)


    Well, yes. It'll be a stock, standard CREATE TABLE statement. As I said, you can't create the table from the execution of the procedure. You'll need to create the table first, then you can run the INSERT ... EXEC statement.

    Thanks for taking the time Gail 🙂