UPDATE dtl
SET 
    dtl.salesmanid = (
        SELECT STUFF((
            SELECT ',' + m.emp_id
            FROM BAS_EMP m
            WHERE CHARINDEX(m.emp_name, dtl.salesman) > 0
              AND m.shp_id = gtss.shp_id 
            FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 1, '')
    )
FROM 
    dat_gtss_dtl dtl
JOIN 
    dat_gtss gtss ON dtl.id = gtss.id
WHERE 
    gtss.sys_netdate > '2025-1-1'  -- 仅更新 sys_netdate > '2025-1-1' 的记录
    AND dtl.salesman IS NOT NULL  
    AND dtl.salesman <> ''       
    AND (dtl.salesmanid IS NULL OR dtl.salesmanid = '');