CTE中')‘错误附近的语法不正确
CTE中')‘错误附近的语法不正确
提问于 2019-04-25 22:52:46
我写了下面的CTE (常用表表达式)
WITH PRODUCTION_CTE(ShortProdNo,BoatRefNumber,ProdNo, CustomerPoNumber,LoadDate, Trailer, VeadaBuilding)
AS
(
SELECT
FBS.BoatNumber AS ShortProdNo,
UOD.BoatRefNumber AS BoatRefNumber,
FBS.ProdNo AS ProdNo,
UOD.CustomerPoNumber AS CustomerPoNumber,
FBS.Shipped AS LoadDate,
FBS.TruckNum AS Trailer,
(CASE
WHEN Rtrim(UOD.CustomerPoNumber)='VEADA-VS1' THEN 'Bldg10'
ELSE 'Bldg4'
END) AS VeadaBuilding
FROM SysproCompanyV.dbo.FlatBenningtonShipping as FBS
INNER JOIN SysproCompanyV.dbo.UsrOrderDetails as UOD
ON FBS.BoatNumber=UOD.BoatRefNumber)我从上面的CTE中得到以下错误：
Msg 102, Level 15, State 1, Line 17
Incorrect syntax near ')'.我不确定为什么会发生这种情况，因为在CTE中允许内部联接，所有的括号都是关闭的，并且名称被正确声明。
Stack Overflow用户
回答已采纳
发布于 2019-04-25 22:55:36
您需要在声明之后立即调用CTE (即PRODUCTION_CTE)：
;with PRODUCTION_CTE as (
. . .
)
select pc.*
from PRODUCTION_CTE pc页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/55852180
复制相关文章
相似问题
腾讯云开发者
