SELECT PROJECT_ID,STAGE_CLASS,QUARTER,PROFILE
FROM
T_AM_BUILD_INFO
UNPIVOT
(
PROFILE
FOR QUARTER IN
([OLD_PROPERTY_ID],[NEW_PROPERTY_ID],[OLD_ADDR_ID],[NEW_ADDR_ID])
)
AS UNPVT
SQLSERVER 列转行
最新推荐文章于 2024-03-20 12:51:40 发布