大家看看这是什么问题?

Superisboy 2003-12-15 11:27:28
SELECT TOP 100 PERCENT dbo.CallInfoOfProductLineAndBU_new.Period AS 月份,
dbo.BUManageRegion.RegionName AS 大区,
dbo.CodeOfProvince.ProvinceName AS 省份, dbo.CodeOfCity.CityName AS 城市,
dbo.Hospital.HospitalName AS 医院名称,
dbo.CodeOfStandardSectionOffice.name AS 标准科室,
dbo.Doctor.SectionOfficeName AS 挂牌科室, dbo.Doctor.DoctorName AS 医生姓名,
SUM(dbo.CallInfoOfProductLineAndBU_new.Call) AS Call_Num,
dbo.XJ_View_CallCard.StaffName
FROM dbo.XJ_View_CallCard LEFT OUTER JOIN
dbo.Doctor INNER JOIN
dbo.CodeOfProvince INNER JOIN
dbo.CodeOfCity ON
dbo.CodeOfProvince.ProvinceCode = dbo.CodeOfCity.ProvinceCode INNER JOIN
dbo.Hospital INNER JOIN
dbo.BUManageRegion INNER JOIN
dbo.RegionManageDoctor2 ON
dbo.BUManageRegion.RegionRowID = dbo.RegionManageDoctor2.RegionRowID INNER
JOIN
dbo.CodeOfStandardSectionOffice ON
dbo.RegionManageDoctor2.SectionOfficeCode = dbo.CodeOfStandardSectionOffice.SectionOfficeCode
ON dbo.Hospital.HospitalRowID = dbo.RegionManageDoctor2.HospitalRowID ON
dbo.CodeOfCity.CityCode = dbo.Hospital.CityCode ON
dbo.Doctor.DoctorRowID = dbo.RegionManageDoctor2.DoctorRowID ON
dbo.XJ_View_CallCard.HospitalId = dbo.Doctor.HospitalRowID RIGHT OUTER JOIN
dbo.CallInfoOfProductLineAndBU_new ON
dbo.RegionManageDoctor2.DoctorRowID = dbo.CallInfoOfProductLineAndBU_new.DoctorRowID
GROUP BY dbo.CallInfoOfProductLineAndBU_new.Period,
dbo.BUManageRegion.RegionName, dbo.CodeOfProvince.ProvinceName,
dbo.CodeOfCity.CityName, dbo.Hospital.HospitalName,
dbo.CodeOfStandardSectionOffice.name, dbo.Doctor.SectionOfficeName,
dbo.Doctor.DoctorName, dbo.XJ_View_CallCard.StaffName
运行了七分四十九分钟,在企业管理器中显示"超时已过期",怎么优化啊?
...全文
20 5 打赏 收藏 转发到动态 举报
AI 作业
写回复
用AI写文章
5 条回复
切换为时间正序
请发表友善的回复…
发表回复
hglhyy 2003-12-21
  • 打赏
  • 举报
回复
接分! UP!
wzh1215 2003-12-21
  • 打赏
  • 举报
回复
恭喜,接分!!
Superisboy 2003-12-21
  • 打赏
  • 举报
回复
已经解决,散分
goldpony 2003-12-15
  • 打赏
  • 举报
回复
up
Superisboy 2003-12-15
  • 打赏
  • 举报
回复
不好意思,是运行了七分四十九秒

11,850

社区成员

发帖
与我相关
我的任务
社区描述
MS-SQL Server 非技术版
社区管理员
  • 非技术版社区
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧