one clarification:
this is what I meant to say. You cannot use this construct to get the output of a stored procedure into a table variable.
declare @table_variable table(f1 varchar(100), f2 varchar(100))
INSERT INTO @table_variable EXEC sp_depends 'anyTableName'
Server: Msg 197, Level 15, State 1, Line 2
EXECUTE cannot be used as a source when inserting into a table variable.
sorry for the confusion.
jambu