Sql如何列转行

select *,(select LEFT(s,len(s)-1) from (
    select (
        select DeptName+',' AS [text()] from HR_Department where Code in (select Code from HR_TrainingRegion where TrainingPlanID ='C835FB0B-49D4-41C2-BABC-2F05FFD93E39' )
        for xml  path('')
        ) as s
    ) as a
) as ValuesString
 from HR_Department