CREATE TABLE #t ([qlr] NVARCHAR(20),[wy] NVARCHAR(40))
INSERT INTO #t ([qlr],[wy]) VALUES(N'测试23',N'分户合同测试1'),(N'测试23',N'分户合同测试2')
CREATE TABLE #tt ([qlr_list] NVARCHAR(MAX),[wy_list] NVARCHAR(MAX))
DECLARE @qlr NVARCHAR(MAX),@wy NVARCHAR(MAX)
EXECUTE [dbo].[usp_TableColumnValueToCommaDelimitedString] #t,[qlr],@qlr OUTPUT
EXECUTE [dbo].[usp_TableColumnValueToCommaDelimitedString] #t,[wy],@wy OUTPUT
INSERT INTO  #tt ([qlr_list],[wy_list]) VALUES (@qlr,@wy)
SELECT [qlr_list],[wy_list] FROM #tt