select * from TbaleOne
unpivot(qty for years in ([],[],[])) as up
go select * from TableTwo
unpivot(grate for subject in [kemu]) as up
具体看图
select * from TbaleOne
unpivot(qty for years in ([],[],[])) as up
go select * from TableTwo
unpivot(grate for subject in [kemu]) as up
具体看图