I guess SQL Server doesn't do auto-remerge like SAS SQL does. You will just have to do the merge yourself. Something like:
create table WORK.MEETING_EVENTS as
select * from connection to MYCONNECTION
(select
a.COMPANY_A,
a.COMPANY_A_ID,
a.EVENT_NAME,
a.COMPANY_B,
a.COMPANY_B_ID,
a.EVENT_ID,
a.EVENT_DT
FROM &MEETING_EVENTS_YEARLY. as a inner join
( select
COMPANY_A,
COMPANY_B,
MAX(EVENT_DT) as select_dt
from &MEETING_EVENTS_YEARLY.
WHERE UPPER(EVENT_NAME) IN ('SCHOOL HOLIDAY','ANNIVERSARY','NEW YEAR EVE','CHRISTMAS')
GROUP BY COMPANY_A, COMPANY_B ) as b
on a.COMPANY_A=b.COMPANY_A and a.COMPANY_B=b.COMPANY_B and a.EVENT_DT=b.select_dt
);
... View more
