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的表中的列 必须在当前使用过.