select V1.ProjGUID,
V1.RegisterVisitTaskGUID,
v.ReceiveCode,
R.QSDate,
(select top 1 VisitType from k_Visit where k_Visit.RegisterVisitTaskGUID = V1.RegisterVisitTaskGUID order by ModiTime desc) AS VisitType,
V2.VisitSetGUID,
R.ContractGUID,
(select top 1 VisitCondition from k_Visit where k_Visit.RegisterVisitTaskGUID = V1.RegisterVisitTaskGUID order by ModiTime desc) AS VisitCondition,
a.VisitEndTime,
a.VisitMyd
from k_RegisterVisitTask V1
join es_Contract R ON V1.AboutBusinessGUID = R.ContractGUID
join k_VisitSet V2 ON V1.RegisterVisitTaskSettingGUID = V2.VisitSetGUID
inner join V_visitObject v on V1.RegisterVisitTaskGUID =v.RegisterVisitTaskGUID
LEFT JOIN (select a.* from k_visit a WHERE not exists(select 1 from k_visit b
WHERE b.RegisterVisitTaskGUID=a.RegisterVisitTaskGUID and b.ModiTime>a.ModiTime) AND a.ModiTime IS NOT NULL) a ON a.RegisterVisitTaskGUID = V1.RegisterVisitTaskGUID
where V1.ProjGUID in (select TOP 200 ProjGUID from dbo.fn_GetMyProject('00000000-0000-0000-0000-000000000000'))
AND VisitSetGUID='00000000-0000-0000-0000-000000000000'
求大神优化,不到1万条数据需要3分钟
- 写回答
- 好问题 0 提建议
- 追加酬金
- 关注问题
- 邀请回答
-
1条回答
悬赏问题
- ¥20 delta降尺度方法,未来数据怎么降尺度
- ¥15 c# 使用NPOI快速将datatable数据导入excel中指定sheet,要求快速高效
- ¥15 再不同版本的系统上,TCP传输速度不一致
- ¥15 高德地图点聚合中Marker的位置无法实时更新
- ¥15 DIFY API Endpoint 问题。
- ¥20 sub地址DHCP问题
- ¥15 delta降尺度计算的一些细节,有偿
- ¥15 Arduino红外遥控代码有问题
- ¥15 数值计算离散正交多项式
- ¥30 数值计算均差系数编程