SQL-无法绑定多部分标识符[已关闭]

我必须在过程中实现现有的SQL查询。

以下是查询:

WITH path(pot, pat, CostCenterID) 
    AS (
    SELECT
        CAST(CAST(Position AS varchar(5)) + '.' AS varchar(30)) AS pos
        , CAST(' . ' AS varchar(30)) AS poi
        , CostCenterID
    FROM
        dbo.View_CostCenter_ActHierarchy AS c
    WHERE
        (ParentID = '          ') 
        AND (Scenario = (SELECT status FROM dbo.Help_Variables WHERE (id = 'actsce'))) 
        AND (Version =  (SELECT status FROM dbo.Help_Variables WHERE (id = 'actver')))

    UNION ALL

    SELECT
        CAST(p.pot + CAST(c.Position AS varchar(5)) + '.' AS varchar(30)) AS pos
        , CAST(p.pat + ' . ' AS varchar(30)) AS poi
        , c.CostCenterID
    FROM
        dbo.View_CostCenter_ActHierarchy AS c 
        INNER JOIN paths AS p ON c.ParentID = p.CostCenterID
    WHERE 
        (c.Scenario = (SELECT status FROM  dbo.Help_Variables WHERE (id = 'actsce'))) 
        AND (c.Version = (SELECT status FROM dbo.Help_Variables  WHERE (id = 'actver')))

)

直到第二天看起来都很好 select-statement . 我得到的错误如下: p.pot , p.pat , paths 和 p.CostCenterID . 错误是:

的多部分标识符。。。无法绑定

有没有人有过这方面的经验,或者给我一些提示,因为我是SQL新手。 你的回答真是太好了! 提前感谢您!