Not directly.
You can store the output of Stored Proc in a temp table like:
Create table #temp
(
... -- define columns here
)
Insert into #temp
EXEC sp_something(...)
And then use temp table in SELECT statement like below:
Select ed.* from EmployeeDetails ed Join #temp t
on ed.EmployeeName = t.EmployeeName
PesoBot again overtook me!
Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"
Stored procedure in a Select Statement
Posted - 04/23/2007 : 05:13:08
