I have two tables and I have to insert unmatched data from Source table to Master table. Also, Matched data from both tables should remains in Master table. Please find the attachment for reference.
there is no data available with us but as far as merge function is concerned you can use -
MERGEDevbrat Tripathi 21 Dec 2016 0 0
[AS TARGET] USING [AS SOURCE] ON [WHEN MATCHED THEN ] [WHEN NOT MATCHED [BY TARGET] THEN ] [WHEN NOT MATCHED BY SOURCE THEN ];