I would like to use the "Select Into" syntax to populate a temptable but instead of using a select statement in the select into I would like to use an execute proc_name statement
Standard Example:
I know the following works
Select * into #myTable from some_real_table
What I want to do:
select * into #myTable from exec my_prop @myParam
The whole purpose in this is to aviod manually defining the temp table since the procedure my_prop might change over time and I would like the select into statement to keep up with the changes.
Thanks
Standard Example:
I know the following works
Select * into #myTable from some_real_table
What I want to do:
select * into #myTable from exec my_prop @myParam
The whole purpose in this is to aviod manually defining the temp table since the procedure my_prop might change over time and I would like the select into statement to keep up with the changes.
Thanks