I have two stored procedures.
Proc1executes a SQL statement and results a data table as a result set.
I need to use the datatable in a select SQL that resides in
proc2as a datasource. like,
SELECT Col1 FROM (Exec Proc1)
How can I do it? This syntax here shows error in SQL Server.