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
列转字符串
作者:RichardCui
出处:https://www.cnblogs.com/yachao1120/
本文版权归作者和博客园共有,欢迎转载,但未经作者同意必须保留此段声明,且在文章页面明显位置给出原文连接,否则保留追究法律责任的权利。该文章也同时发布在我的独立博客中-RichardCuiBlog。