select unt.upd_dte, unt.*
from CDSADR_M unt
left join CDSADR_M trn on trn.ctm_nbr = unt.ctm_nbr and trn.adr_cde = '91' and trn.adr_flg = unt.adr_flg
where trn.ctm_nbr is null and unt.adr_flg <> 'P' and convert(varchar, unt.atn_end) like '%?%'
and unt.upd_dte < (select top 1 StartDate from Integration.Translate_Master order by ID desc)

000200010470

000200008880