SQL中获取多条记录拼接成字符串

declare @aa nvarchar(200)
set @aa=(select STUFF((
select ','+LTRIM(list.TempName1) from
(select TempName1 from dbo.fnSplit2('012:ST|002:00000|343:434|tytr:56765','|',':')
where TempName1 not in(select CategoryCode from SY_CheckItem where AccountId=3102))list
for xml path('')),1,1,'')alllist)
print @aa