如何在使用insert from select之前检查副本

I have the following code to get data from linked server but how can i check whether there is a duplicate record or not in I have the following code to get data from link