SQL SERVER – Insert Data From One Table to Another Table – INSERT INTO SELECT – SELECT INTO TABLE |

Paul (9): I did it like this: INSERT INTO MRA..T_MRA_MBR (MBR_ID, NCPDP_PRVDR_NUM) SELECT MBR_ID, NCPDP_PRVDR_NUM FROM P350..T_AH_MBR WHERE MBR_ACTV_IND = ‘Y’ AND MBR_ID NOT IN (SELECT MBR_ID FROM MRA..T_MRA_MBR) ...

blog.sqlauthority.com