sql2005 行列转换的例子

最新推荐文章于 2024-10-30 20:11:38 发布

bird1983

最新推荐文章于 2024-10-30 20:11:38 发布

阅读量483

点赞数

文章标签： sql pivot

本文链接：https://blog.csdn.net/bird1983/article/details/2031506

版权

SELECT     categoryproductid, [0] AS p0, [1] AS p1, [2] AS p2, [3] AS p3, [4] AS p4, [5] AS p5, [6] AS p6, [7] AS p7, [8] AS p8, [9] AS p9
FROM         (SELECT     categoryproductid, sequence, propertyname
                       FROM          CategoryProductsProperty) AS CategoryProductsProperty PIVOT (max(CategoryProductsProperty.propertyname) FOR sequence IN ([0], [1],
                      [2], [3], [4], [5], [6], [7], [8], [9])) AS pvt