摘要:
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_Depart 阅读全文