sql递归拼接

with my1 as 
(
select * from SYS_OrgUnit where  oucode='100101102101' 
union all 
select SYS_OrgUnit.* from  my1,SYS_OrgUnit where my1.ParentOUCode=SYS_OrgUnit.OUCode)

select my1.OUName+'\' from my1 inner join SYS_OrgUnit on SYS_OrgUnit.OUCode=my1.ParentOUCode  where my1.oucode <> '100' order by my1.OULevel
for xml path ('') 

中国石油规划总院\计算机中心炼化部\生产运行研究室\

SELECT pvt.ID, pvt.[3] InquiryDate , pvt.[4] AS KeepDate, pvt.[5] AS ProFoundDate
FROM
(select ID, ControlCode,PlanTime from ProControl) as tmp  
PIVOT(Max (PlanTime) FOR ControlCode IN ( [3], [4], [5] )) AS pvt

//from的表中的列 必须在当前使用过.