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.OULevelfor xml path ('') 

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

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

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