calling stored procedure

[raghulvarma]

Is there a posibility to call a stored procedure inside subquery? if so how?

[deric]

select * from myTable
where ID = (exec dbo.myProc(@param1,@param2)) --if myProc returns a value

[deepuv04]

Is there a posibility to call a stored procedure inside subquery? if so how?

Hi,
It is not possible to call a stored procedure inside a subquery, instead use function or
dump the data into temporary table and work on it.

Thanks

[debasisdas]

You can't call a procedure inside a sub query . Use a function instead.

[deric]

sorry.. was thinking of functions, instead of stored procedures, in my previous post..

[deepuv04]

sorry.. was thinking of functions, instead of stored procedures, in my previous post..

[code =sql]
if the function is returning single value
SELECT dbo.Function_Name(parameter_list) .....
WHERE dbo.Function_Name = value

if the function is returning a table then
SELECT * from dbo.Function_Name(parameter_list) .....
[/code]