Have you ever tried using INNER JOIN..if possible can you try it whether it works.

l

for example :-

Insert into

select distinct kw_id

from StageDB.dbo.tt_wf_49b955a9_gtsang_2BC a -- 10000o rows

INNER JOIN DW_KWDM_KW_GRP_MAP b

ON a.KW_ID <> b.KW_ID

AND b.kw_ID = 6675