raresql.com
SQL SERVER 2012 – Stored Procedure – Insert into exec with result set is Possible
In my earlier article, I discussed that if you need to use result set with any stored procedure then you cannot insert the result set into a table. It generates the error no 102, Incorrect syntax …