1. --创建测试表
    2. CREATE TABLE [dbo].[Deptment]([ID] INT IDENTITY,[PID] INT,DeptName NVARCHAR(50)) GO
    4. --递归查询 sql server2014下运行正常
    5. WITH TempDeptment ([ID],[PID],[DeptName],[Conjunction]) AS
    6. (
    7.     SELECT [ID],[PID],[DeptName], CAST([DeptName] AS Nvarchar(1000)) FROM [dbo].[Deptment] WHERE [PID] = 0
    8.     UNION ALL
    9.     SELECT d.[ID], d.[PID], d.[DeptName], CAST(([Conjunction] + N'/' + d.[DeptName]) AS Nvarchar(1000))  FROM TempDeptment AS td,[dbo].[Deptment] AS d WHERE td.[ID] = d.[PID]
    10. )
    11. SELECT [ID], [Conjunction] FROM TempDeptment