SQL实现数据结构纵向转换

 

 

select olnID as流水号,max(case when ftrID=3764 then olnoValue end) 深 ,
                       max(case when ftrID=3765 then olnoValue end) 高,
                       max(case when ftrID=3766 then olnoValue end) 宽
 
                   
 from  dbo.OrderLineOptions  group by olnID