获取去掉交集部分的数据

 select * from @tbMN a where not exists (
  select * from ModelLossInfo where ModelName=a.ModelName
  and PN=a.PartNumber and LineName=@LineName
  and CONVERT(varchar(12),ScanDate,23)=convert(varchar(12),@ScanDate,23)

原文地址:https://www.cnblogs.com/lgxll/p/2661966.html