Select Max Date from this below temp table.
SELECT ORDER_DETAIL_MARKET_CODE, NEW_OPER, MAX(ACTIVITY_DATE)
from #final
GROUP BY ORDER_DETAIL_MARKET_CODE, NEW_OPER
ORDER BY ORDER_DETAIL_MARKET_CODE
Select Max Date from this below temp table.
SELECT ORDER_DETAIL_MARKET_CODE, NEW_OPER, MAX(ACTIVITY_DATE)
from #final
GROUP BY ORDER_DETAIL_MARKET_CODE, NEW_OPER
ORDER BY ORDER_DETAIL_MARKET_CODE
What's the problem?
I got it. I am just trying to get max date for each user.