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