22,209
社区成员
发帖
与我相关
我的任务
分享
select fcurraddr,left(fcurraddr,charindex('@',fcurraddr)),* from dbo.TPATIENTVISIT
where FCYDATE>='20180701'
and not exists(select 1 from tstandardmx where fcode='Gbaddr' and (fbh=left(fcurraddr,9)) and (fmc=substring(fcurraddr,10,charindex('@',fcurraddr)-9)))
select fcurraddr,left(fcurraddr,charindex('@',fcurraddr)),* from dbo.TPATIENTVISIT
where FCYDATE>='20180701'
and (left(fcurraddr,charindex('@',fcurraddr)) not in (select fbh+fmc from tstandardmx where fcode='Gbaddr'))
WITH RECOMPILE
SELECT
fcurraddr,
LEFT(fcurraddr, CHARINDEX('@', fcurraddr)),
*
FROM
dbo.TPATIENTVISIT
WHERE
FCYDATE >= '20180701'
AND NOT EXISTS
(
SELECT
1
FROM
tstandardmx
WHERE
fcode = 'Gbaddr'
AND LEFT(fcurraddr, CHARINDEX('@', fcurraddr) = fbh + fmc
);