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