基于类型结果串联列值

Question

  Declare @name nvarchar(max),@Id int
  SELECT @Id=[EmpType],@name =ISNULL(@name + ',','')+[UserName] FROM [dbo].[TestTable]
  Group by [EmpType]
  SELECT @Id,@name

获取此代码时出错，如何获取结果employee type-wise串联用户名

预期结果集

Answer 1

您可以在下面尝试使用STUFF（）函数

SELECT [EmpType],  abc = STUFF(
             (SELECT ',' + [UserName]
              FROM [dbo].TestTable] t1
              WHERE t1.[EmpType] = t2.[EmpType]
              FOR XML PATH (''))
             , 1, 1, '') from [dbo].TestTable] t2
group by [EmpType];