Luis Cazares (3/27/2014)

---

The subquery looks fine, you're filtering using JOINs. You could change them to IN or EXISTS and you might have a slight performance gain, but it might...

Thank you for the help but the my last reply was the query that I was looking for.

Thank you for the help and information. I actually had to do the following:

SELECT Distinct T.ID1,

T.ID2

FROM Processing P WITH (NOLOCK)

INNER JOIN #IDTEMP...

Thank you everyone for your insight and help. Hope everyone has a great weekend.:-)

Thanks everyone for your help. But for curiosity sake. How would it look with a MERGE statement?