That's a valid point. But what if my query is something like this

--------- some logic

--------- some logic

where empid=(select empid from #emp where deptid=2)

The objective of the query is to execute the logic for each empid.