select distinct cd.cdr_recordId_backup, count(*) from tbl_TBA_Claims c with (nolock) inner join tbl_TBA_ClaimDetail cd with (nolock) on c.claimid = cd.claimid left outer join tbl_CDR_Distributors cdr with (nolock) on cd.cdr_recordId_backup = cdr.cdr_recordId and cdr.ownerid = 1 and cdr.fsl_tableCode = 'MFR' where c.ownerid = 1 and c.fsl_tableCode = 'MFR' and year(c.invoiceStart) IN ('2018','2017') and cdr.cdr_recordId is null and coalesce(cd.cdr_recordId_backup,0) > 0 group by cd.cdr_recordId_backup select fsl_dstID from tbl_CDR_Distributors with (nolock) where cdr_recordId = and fsl_tableCode = 'CHO' select cdr_recordID from tbl_CDR_Distributors with (nolock) where ownerid = 1 and fsl_TableCode = 'MFR' and fsl_dstid = order by cdr_recordId asc update cd set cdr_recordid_new = , cdr_recordId_2_status = 'REMAPPED_2' from tbl_TBA_ClaimDetail cd inner join tbl_TBA_Claims c on cd.claimid = c.claimid where c.ownerid = 1 and c.fsl_TableCode = 'MFR' and cd.cdr_recordID_backup =