quote:

---

Originally posted by akashenk

I have two temp tables (as part of an intermediary procedure) that have the same structure (Table A and Table B).

Table A: EmployeeId, HiredDate
Table B: EmployeeId, HiredDate

Table A contains all possible records, Table B contains a subset of Table A. In other words, a record may exist in both Table A snd B, but ther may be some records which exist in Table A, but not Table B.

I can retrieve both of these result sets of data and process them so that I know which records are in both Table A and B, and which are only in Table A, however, I wonder if there is a more efficient way of doing this using T-SQL so that I don't have to retrieve two result sets with so many duplicate records. Is there a way to retrieve a "merged" resultset through a Join or some other operation, and create a field which designates that the record exists in Table A, but not Table B?

So for example, the retrieved resultset would have EmployeeId, HiredDate and some additional field "FoundInB", or whatever which designates whether the record exists in Table B or not.

Thanks in advance!

---