I tried many approaches without any luck. maybe the SQL 2016 will work on the select * into Table from exec sp, as this will create a table and insert whatever the stored procedure returns data into the table. Thanks, lw. The problem is that you created a dynamic stored procedure that returns an unknown set of data.

Transact-SQL is a database procedural programming language. Microsoft's monopoly, used in SQL Server. Procedural languages are designed to extend SQL's abilities while being able to integrate well with SQL.Several features such as local variables and string/data processing are added. This is a coder's book. It's intended to help developers build applications that make use of Transact-SQL. It's not about database administration or design. It's not about end-user or GUI application development. It's not even about server or database performance tuning. It's about developing the best Transact-SQL code One popular extension for SQL is T-SQL (Transact-SQL) that is closely related to the SQL language and it adds a plenty of programming constructs too that are native to the SQL. In this tutorial, we will discuss the SQL server basics in details and a set of basic SQL commands that are frequently used by developers. The question is not how to call a stored procedure from within another stored procedure, I know I don't need another connection. My question is about the internal workings of SQL server and whether it will affect performance at all, as for instance if it will in the background create a different db connection to execute the embbed sproc. Thanks By: Greg Robidoux Overview. A stored procedure is nothing more than prepared SQL code that you save so you can reuse the code over and over again. So if you think about a query that you write over and over again, instead of having to write that query each time you would save it as a stored procedure and then just call the stored procedure to execute the SQL code that you saved as part of the In t