Ok that answers my question. Thank you very .... much 🙂 .

But as i was going through your question one more question pop up in my mind.

This code is...

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...