行转列。Value值为String类型，如果合并
- SQL code
select distinct tp.[order],tp.Module,(case tpt.Name when 'Color' then Value else '' end) Color,(case tpt.Name when 'Total' then Value else '' end) Total,(case tpt.Name when 'DeliveryDate' then Value else '' end) DeliveryDate from UserDataModel.T_LeanLinePlan tp left joinUserDataModel.T_LeanLinePlanAttribute tpton tp.LeanLinePlanId=tpt.LeanLinePlanId
value值为‘’，所有数据集出现很多空白的
[解决办法]
- SQL code
select tp.[order],tp.Module,Max(case tpt.Name when 'Color' then Value else '' end) Color,Max(case tpt.Name when 'Total' then Value else '' end) Total,Max(case tpt.Name when 'DeliveryDate' then Value else '' end) DeliveryDate from UserDataModel.T_LeanLinePlan tp left joinUserDataModel.T_LeanLinePlanAttribute tpton tp.LeanLinePlanId=tpt.LeanLinePlanIdWhere Name in('Color','Total','DeliveryDate')Group by tp.[order],tp.Module