Nested tasks not possible?
Situation: from a main routine, I execute a subroutine with sp_exec. inside this subroutine, some calculations are done (a generated SQL statment). If I execute this SQL statement with sp_exec it seems it's not executed at all. no error message either. Can't find the reason. (SQLStatement is ok, checked)
exec mainroutine
-- in loop: sp_exec subroutine
-- in loop: sp_exec sql statement
Question: can you add another process from within a parallel process?
Wilfred
The best things in life are the simple things