行转列。Value值替String类型，如果合并

行转列。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

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