Viewing 3 posts - 1 through 4 (of 4 total)
Of course, Tim is quite right. In the query the Employee_Id generated are not constrained to District_Id = 0x0003E. If this is a true requirement then the IN condition must be kept.
To...
May 25, 2006 at 4:41 am
#639990
I wasn't sure that was true for SQL Server, might it depend upon which version is being used?
Either way, the use of the IN or EXISTS would imply...
May 25, 2006 at 3:45 am
#639980
Just a slight improvement, but I would change Tim's IN clause back to an EXISTS in the following form:
May 25, 2006 at 2:47 am
#639968