如何将行转置为列

您不需要将行转置为列。您需要将[SODeaderId]列的不同[SODeaderId]连接到由逗号分隔的字符串中。最简单的方法之一是使用 XML PATH（''）。



您的查询应该是这样的：

You don't need to transpose rows into columns. You need to concatenate [SODetailId] column values by distinct [SOHeaderId] into a string separated by commas. One of the simplest ways to do this is to use XML PATH('').

Your query should be something like this:

SELECT DISTINCT [SOHeaderId],
                STUFF((SELECT ',' + CAST([SODetailId] AS VARCHAR(10))
                       FROM   [TableName] t1
                       WHERE  t1.[SOHeaderId] = t2.[SOHeaderId]
                       FOR XML PATH('')), 1, 1, '')
FROM   [TableName] t2

我假设[SODetailId]的数据类型是 INT ，所以我将它转换为 VARCHAR（10）。



参考文献：

1. STUFF AND FOR XML PATH for String Concatenation [ ^ ]

2. 使用FOR XML PATH和STUFF来加强 [ ^ ]

I am assuming that the data type of [SODetailId] is INT, so I am casting it to VARCHAR(10).

References:
1. STUFF AND FOR XML PATH for String Concatenation[^]
2. Using FOR XML PATH and STUFF to CONCATENATE[^]