怎么让结果横向输出


让结果横向输出，且nvcGroupName 字段取消重复


参考代码：
SELECT DISTINCT [D].[nvcID],[D].[nvcCarName]
,[A].[nvcGroupName]
,COUNT([B].[nvcName]) AS [nvcName]
FROM [dbo].[FITGroup] A
,[dbo].[FITGroupPeople] B
,[dbo].[FITCarDetail] C
,[dbo].[FITCar] D
WHERE [D].[nvcCarName] = '1车' AND
[D].[nvcID] = [C].[nvcFITCarID] AND
[C].[nvcFITGroupInfoID] = [A].[nvcID] AND
[A].[nvcID] = [B].[nvcFITGroupID]
GROUP BY [D].[nvcID],[D].[nvcCarName],[A].[nvcGroupName]
[解决办法]

DECLARE?@s?NVARCHAR(4000)
 ?SET?@s?=?''
 ?SELECT??@s?=?@s?+?','?+?QUOTENAME(nvcgroupname)
 ?????????+?'=max(case?when?[nvcgroupname]='?+?QUOTENAME(nvcgroupname,?'''')
 ?????????+?'?then?[nvcname]?else?''0''?end)'
 ?FROM????tb
 ?GROUP?BY?nvcid?,
 ?????????nvccarname?,
 ?????????nvcgroupname
 ?EXEC('select?nvcid,nvccarname'+@s+'?from?tb?group?by?nvcid,nvccarname')