34,575
社区成员
发帖
与我相关
我的任务
分享
select
Distinct CRCTL1 as PolicyID
from LifeMir.dbo.CMSUSREL A
left join LifeMir.dbo.NBSPCNTR B
On A.CRCTL1=B.PCPOLN
where
(CRALPH ='OW1' or (CRALPH='INS' and CRCTL2=0))
AND
NOT Iexists( select 1 from LifeMir.dbo.NBSPCNTR where PCUSR6 like 'C__9%' and
(PCAPPY*10000+PCAPPM*100+PCAPPD)=CONVERT(varchar(12) , getdate(), 112 and CRCTL1=a.CRCTL1));
--这样不行?
select
Distinct CRCTL1 as PolicyID
from LifeMir.dbo.CMSUSREL A
left join LifeMir.dbo.NBSPCNTR B
On A.CRCTL1=B.PCPOLN
where (CRALPH ='OW1' or (CRALPH='INS' and CRCTL2=0))
and PCUSR6 like 'C__9%' and
(PCAPPY*10000+PCAPPM*100+PCAPPD)=CONVERT(varchar(12) , getdate(), 112)