我遇到一个SQL执行错误的问题。我正在尝试执行一个视图,但我得到了一个“执行超时过期”的错误。我运行的代码如下所示。我需要将此视图作为视图运行,因为这些表链接到一个自动更新的dbo,并且我需要此视图与MS Access报表使用它时的视图一样是最新的。(根据我的理解,视图不需要手动执行即可保持最新)
我试图更改所有的超时位置,包括在工具->选项中,在登录连接选项中,在注册表编辑器中,但我仍然收到错误。
它在30秒后超时,所以我还可以在哪里更改它?这是不是因为我没有完全的"IT管理员“权限(即使看起来我的更改已保存)而无法工作?和/或有没有更好的方法来写这段代码,让它正常工作?
基本上,表1中的信息也在表2中。我想要表2中的所有信息,除了与表1中匹配的信息。
提前感谢您!
SELECT TOP (100) PERCENT dbo.vwCOVIDLocations2.Hospital, dbo.vwCOVIDLocations2.Department, dbo.vwCOVIDLocations2.MRN, dbo.vwCOVIDLocations2.[Patient Name], dbo.vwCOVIDLocations2.[Order Date],
dbo.vwCOVIDLocations2.Result
FROM dbo.vwCOVIDDetected2 LEFT OUTER JOIN
dbo.vwCOVIDLocations2 ON dbo.vwCOVIDDetected2.MRN <> dbo.vwCOVIDLocations2.MRN AND dbo.vwCOVIDDetected2.[Order Date] <> dbo.vwCOVIDLocations2.[Order Date] AND
dbo.vwCOVIDDetected2.Result <> dbo.vwCOVIDLocations2.Result
GROUP BY dbo.vwCOVIDLocations2.Hospital, dbo.vwCOVIDLocations2.Department, dbo.vwCOVIDLocations2.MRN, dbo.vwCOVIDLocations2.[Patient Name], dbo.vwCOVIDLocations2.[Order Date], dbo.vwCOVIDLocations2.Result
ORDER BY dbo.vwCOVIDLocations2.[Patient Name]发布于 2020-10-16 13:35:20
我不确定这是否有帮助,但我不会增加超时。我会重写查询以加快执行速度,尤其是左外部连接。您可以尝试以下操作:
SELECT TOP (100) PERCENT dbo.vwCOVIDLocations2.Hospital
,dbo.vwCOVIDLocations2.Department
,dbo.vwCOVIDLocations2.MRN
,dbo.vwCOVIDLocations2.[Patient Name]
,dbo.vwCOVIDLocations2.[Order Date]
,dbo.vwCOVIDLocations2.Result
FROM dbo.vwCOVIDLocations2
WHERE NOT EXISTS (
SELECT 1 FROM dbo.vwCOVIDDetected2
WHERE
dbo.vwCOVIDDetected2.MRN = dbo.vwCOVIDLocations2.MRN
AND dbo.vwCOVIDDetected2.[Order Date] = dbo.vwCOVIDLocations2.[Order Date]
AND dbo.vwCOVIDDetected2.Result = dbo.vwCOVIDLocations2.Result
)
GROUP BY dbo.vwCOVIDLocations2.Hospital
,dbo.vwCOVIDLocations2.Department
,dbo.vwCOVIDLocations2.MRN
,dbo.vwCOVIDLocations2.[Patient Name]
,dbo.vwCOVIDLocations2.[Order Date]
,dbo.vwCOVIDLocations2.Result
ORDER BY dbo.vwCOVIDLocations2.[Patient Name]https://stackoverflow.com/questions/64375111
复制相似问题