shahsn11 (7/30/2012)
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.
You can execute the logic for sets of employees in the department instead of for each empid.
--Jeff Moden
Change is inevitable... Change for the better is not.