1. What is the order of join of the sub query you want.
2. I think you can remove DISTINCT because you select c.[id] not duplicate
3. Need more infomation

Hi, because this is large table with 15 milion rows, so my suggestion is split it into small pieces. Here my code

SELECT * INTO exportLogTable2 FROM...

Hi, you can try this script:

DECLARE @BrgyCode VARCHAR(5) = '23548';
SELECT
    Ran.NextID,
    Res.ResidentID,
    @BrgyCode + '-' + CAST(Ran.NextID AS VARCHAR (30)) AS NewResidentID,
    Res.ResLogDate
INTO #TempResident