Passing EXEC statement as a parameter to another procedure

[LinsLo]

Is is possible to pass an execute procedure statement into a procedure call as an incoming parameter?

For example:
__________
EXEC Proc_MyProc
@ID,
@name,
EXEC Proc_getContent @ID,
@address

________________

Let me know your thoughts.

Thanks!

 

[nigelrivett]

No. You need to set a variable from the exec then pass that.

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.