server sql 列转横

功能：将一条记录，转换成 多行 

PS  ：空记录，未生成记录

示例：

 

 

 转后效果：

语句：

 

select * from (
select
b.START_VAL
,b.ADD_VAL
,b.CUR_DIST
,b.LES_VAL
,b.BAC_VAL
,b.OUT_VAL
,b.OTH_LES_VAL
,b.FINA_VAL
from cgenius..STK_PVSAIPM_main a inner join cgenius..STK_PVSAIPM_SUB b
on a.seq=b.p_seq
where a.isvalid=1 and b.isvalid=1
and b.SEQ=1
)t1 UNPIVOT (Orders FOR Employee IN (START_VAL, ADD_VAL, CUR_DIST, LES_VAL, BAC_VAL, OUT_VAL, OTH_LES_VAL, FINA_VAL )
)AS unpvt;