动态SQL Server数据透视表

ORDER_ID

name

SET @query = 'SELECt ' + @cols + ' from          ( SELECt ORDER_ID, DSC_NAME -- <--- you didn't select the name here FROM test        ) x        pivot         ( MIN(ORDER_ID) for DSC_NAME in (' + @cols + ')        ) p '

并使用

MAX(DSC_Name)

MIN(ORDER_ID)

SET @query = 'SELECt '+ @cols + ' from          ( SELECt DSC_NAME, Name FROM test        ) x        pivot         ( MAX(DSC_Name) for NAME in (' + @cols + ')        ) p ';

SQL小提琴演示

这将为您提供：

|     DWG_DOC | EQIP_1 | EQIP_2 |        PART |    PRCS |---------------------------------------------------------| 34-1500-XXX |  C0403 |  C4054 | 34-1500-013 | 88-0000 |