Find the Subtasks That Did Not Execute
SQL walkthrough: expand each task into its numbered subtasks with a recursive CTE, then keep the pairs with no execution row.
SQL walkthrough: expand each task into its numbered subtasks with a recursive CTE, then keep the pairs with no execution row.