Hi Don,

Can you please check below query -

SELECT c.*, h.*

FROM #CONTACT c

INNER JOIN (

SELECT Accountno, ROW_NUMBER() OVER(PARTITION BY accountno ORDER BY lastdate) Rownum ,RECID FROM #History

GROUP BY Accountno,LastDate,RECID)...

Thnks buddies its grt stuff. it just saved my lot of time.