SQLServer 行转列

时间：2021-08-18 15:09:05 收藏：0 阅读：10

DECLARE @cmd NVARCHAR(MAX);
DECLARE @names NVARCHAR(MAX);

SET @names = STUFF(( SELECT ‘,‘ + Name
                     FROM   dbo.ProposedProjectSettings
                     WHERE  ProposedProjectID = ‘100012‘
                   FOR
                     XML PATH(‘‘)
                   ), 1, 1, ‘‘);
SET @cmd = ‘
SELECT  *
FROM    ( SELECT    Name ,
                    Value
          FROM      dbo.ProposedProjectSettings
          WHERE     ProposedProjectID = ‘‘100012‘‘
        ) p PIVOT( MIN(Value) FOR Name IN ( ‘+@names+‘ ) )
AS pvt;‘;

EXEC(@cmd)

转置前
技术分享图片

转置后
技术分享图片

原文：https://www.cnblogs.com/xuxuzhaozhao/p/15156119.html