sqlServer 字符串分割与转换后拼接函数

create function changeDeptStr(@targetStr varchar(max))

  returns varchar(max)
  as
  begin

declare @strResult varchar(max)
select @strResult= STUFF((select ','+CONVERT(varchar,id) from
(
select org.Id from (
        select value from (
       select code=CONVERT(xml,'<root><v>'+REPLACE(@targetStr,',','</v><v>')+'</v></root>')
     )A
outer apply
(
  select value=N.v.value('.','varchar(100)') from A.code.nodes('/root/v')N(v)
)B
)c inner join  OrgIdOldIdMapp_PTR org on c.value=org.OldId

)k for xml path('')),1,1,'')

return @strResult
end