WRITTENPREMIUMLEGACY as NewBusinessLegacy ,ACCOUNTINGDTS as AccountingDtsLegacyNewBusiness ,TRANSCODE_EU as TransCodeNewBus ,POLICYNOLEGACY as PolicyNoLegacyNewBus ,CLASSCODELEGACY as ClassCodeNewBus ,RECORDNUMBER as RecordNumberNewBus ,LEGACYPROCESSDATES as LegacyProcessDatesNewBus ,EFFECTIVE as EffectiveNewBus ,EXPIRATION as ExpirationNewBus ,if(LEGACYPROCESSDATES > EFFECTIVE ,LEGACYPROCESSDATES, EFFECTIVE) as NewBusinessDate ,PolicyCancelDate as PolicyCancelDateNewBus Resident [Legacy3] where POLICYNOLEGACY in (select PolicyNoLegacy from Legacy3 where TransCode_EU = '01' );
WRITTENPREMIUMLEGACY as NewBusinessLegacy ,ACCOUNTINGDTS as AccountingDtsLegacyNewBusiness ,TRANSCODE_EU as TransCodeNewBus ,POLICYNOLEGACY as PolicyNoLegacyNewBus ,CLASSCODELEGACY as ClassCodeNewBus ,RECORDNUMBER as RecordNumberNewBus ,LEGACYPROCESSDATES as LegacyProcessDatesNewBus ,EFFECTIVE as EffectiveNewBus ,EXPIRATION as ExpirationNewBus ,if(LEGACYPROCESSDATES > EFFECTIVE ,LEGACYPROCESSDATES, EFFECTIVE) as NewBusinessDate ,PolicyCancelDate as PolicyCancelDateNewBus Resident [Legacy3] where Exists(PolicyNoLegacy,POLICYNOLEGACY);
WRITTENPREMIUMLEGACY as NewBusinessLegacy ,ACCOUNTINGDTS as AccountingDtsLegacyNewBusiness ,TRANSCODE_EU as TransCodeNewBus ,POLICYNOLEGACY as PolicyNoLegacyNewBus ,CLASSCODELEGACY as ClassCodeNewBus ,RECORDNUMBER as RecordNumberNewBus ,LEGACYPROCESSDATES as LegacyProcessDatesNewBus ,EFFECTIVE as EffectiveNewBus ,EXPIRATION as ExpirationNewBus ,if(LEGACYPROCESSDATES > EFFECTIVE ,LEGACYPROCESSDATES, EFFECTIVE) as NewBusinessDate ,PolicyCancelDate as PolicyCancelDateNewBus Resident [Legacy3] where Exists(PolicyNoLegacy,POLICYNOLEGACY);
