列转字符串

DECLARE @HuiQianHandlers NVARCHAR(100)=''

SELECT * INTO #temp
FROM dbo.Fun_TransferStrToTable(@chk_valueStr)

SELECT @HuiQianHandlers=(
SELECT DISTINCT maxLeader+',' FROM dbo.TB_GroupLeader A
JOIN #temp B ON a.GroupName=B.str2table
AND LocationName='上海'
FOR XML
PATH (''))
SELECT @HuiQianHandlers=SUBSTRING(@HuiQianHandlers,0,LEN(@HuiQianHandlers)-1)
UPDATE dbo.FM_ReleatedTrade SET HuiQianHandlers=@HuiQianHandlers WHERE TaskID=@TaskID

转载于:https://www.cnblogs.com/yachao1120/p/7449546.html